microsoft / microsoft/powerbi-powershell

Odd behaviour from Get-PowerBITable

Open
#397 0 comments 0 reactions 0 assignees View on GitHub

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.
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/

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.