microsoft / microsoft/sql-server-samples
2. Open the file using Power BI.
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
I was following the guide at this link and it looked pretty simple, except for the fact that doesn't work.
I download the file DMA Reports V3.1.pbix and as soon as I run it asks for the server and database credentials.
I enter them and I load, here is where the problem starts:
Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Schema=dbo
Item=ReportData
Table=[Table]
It looks like it's searching for something that is not there.
I do believe this Power BI file must be pointing to a specific database or set of information but this is not specified in your guide.
Explain, please
Contributor guide
No contributing guide indexed for this repository
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 with the Power BI Reports guide linked in the issue and the downloaded DMA Reports V3.1.pbix file. Reproduce the load using the supplied server and database credentials, then investigate the missing dbo.ReportData entry shown in the error. Done means the sample opens successfully with documented prerequisites, or the guide clearly explains the required database and data.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- data-visualization, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100