microsoft / microsoft/powerbi-powershell
Odd behaviour from Get-PowerBITable
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 413
- Forks
- 134
- Avg merge
- 33m
- Merged PRs (30d)
- 1
Description
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.
This is to grant you insight in the dataset configuration.
### Tasks
- [ ] https://www.reddit.com/r/PowerShell/comments/17993h9/odd_issue_with_powerbi_cmdlet_getpowerbitable/
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the reported Get-PowerBITable command with the provided DatasetId, WorkspaceId, table name, and First value. Compare the returned Name, Columns, Rows, and Measures fields with the dataset shown in Power BI Online; done means the expected table metadata is populated or the limitation is documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, powershell
- Domain
- cli
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100