Skip to content

Odd behaviour from Get-PowerBITable #397

@Drag-NDrop

Description

@Drag-NDrop

Hello,

I'm experiencing a weird issue with Get-PowerBITable.

I only get the names of my tables, when i run the command, scoped in on the dataset, workspace and table i want, i get nothing but a name back. The rest of the expected output columns are empty.

I find it odd, as i see this command work for other people. And cannot see what I'm surposedly doing different.
The author of this guide, for example.

I've verified the findings, by creating a new dataset, with new tables and data inside. And gotten the same results.
Odd thing is, I'm seeing the dataset, tables and row data, just fine in PowerBI, in the Office365 Portal.
The table in question, contains 10 rows.

The command and output, is as follows:
Get-PowerBITable -DatasetId $WorkingDataSetId.Id -WorkspaceId $WorkspaceId -Name 'table_SalesPerson' -First 3

Name                         Columns     Rows            Measures
----                      -------        ----               --------
table_SalesPerson                                                                

This is a overview so you can see that the data is in fact visible in PowerBI Online.
image

This is to grant you insight in the dataset configuration.
image

### Tasks
- [ ] https://www.reddit.com/r/PowerShell/comments/17993h9/odd_issue_with_powerbi_cmdlet_getpowerbitable/

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions