search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
10.08k stars 8.89k forks source link

2. Open the file using Power BI. #916

Open francesco1119 opened 3 years ago

francesco1119 commented 3 years ago

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:

Problem

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

francesco1119 commented 3 years ago

I now have it, I need to

  1. Create DMAReporting and import data with this PowerShell script
  2. Point the .pbix to DMAReporting.

That wasn't easy, there is no documentation. What's the difference between DMAReporting and DMAWarehouse? In what case I have to use one or another? In which order I should process the scripts? etc, ...

...we need documentation on the page