Using Power Bi online dataset

[marcodea]

I created one PBIX file with dataset definition and varius PBIX files for report creation, using Power BI services as datasource.

Is it possibile to check datasource info in desktop client? When I open the PBIX file, the only info I see is CONNECTED TO POWER BI ONLINE DATA SET on the righ corner of the window.

Regards

[Greg_Deckler]

Not from the client itself I believe. You can copy the pbix to a zip file and open up the Connections document in Notepad to see the connection information.

[marcodea]

Dear @Greg_Deckler thanks for the reply but unfortunatly I didn't undertsand what to do.

Could you give me additional info?

[Greg_Deckler]

Sure, go to File Explorer and find your Power BI Desktop file. It has a PBIX extension. Copy that file and rename it to a .ZIP extension.

So, copy MyFile.pbix to "MyFile (Copy).pbix" and then rename "MyFile (Copy).pbix" to MyFile1.zip.

If you are good at a command prompt you can just use:

copy MyFile.pbix MyFile.zip

Then, open the .zip file in File Explorer. You will see a "Connections" file with no extension. Double-click it and when it prompts you, choose Notepad or some other text viewer to open it. You will see the connection information in the file. It will refer to a GUID I believe that identifies the dataset in the Power BI Service.

[marcodea]

@Greg_Deckler your explanation was very useful but I can't find GUID field in Connections file. Maybe his format has changed during time.

{"Version":1,"Connections":[{"Name":"EntityDataSource","ConnectionString":"Data Source=pbiazure://api.powerbi.com;Initial Catalog=e197d4d8-0139-4b49-b78a-3c054d890ca1;Identity Provider=\"https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, 7f67af8a-fedc-4b08-8b4e-37c4d127b6cf\"","ConnectionType":"pbiServiceLive","PbiServiceModelId":2169144,"PbiServiceGroupId":"3db39692-effc-4f2a-ba48-1accb1975f7e","PbiModelVirtualServerName":"sobe_wowvirtualserver","PbiModelDatabaseName":"e197d4d8-0139-4b49-b78a-3c054d890ca1"}]}

[Greg_Deckler · Accepted solution]

{"Version":1,"Connections":[{"Name":"EntityDataSource","ConnectionString":"Data Source=pbiazure://api.powerbi.com;Initial Catalog=e197d4d8-0139-4b49-b78a-3c054d890ca1;Identity Provider=\"https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, 7f67af8a-fedc-4b08-8b4e-37c4d127b6cf\"","ConnectionType":"pbiServiceLive","PbiServiceModelId":2169144,"PbiServiceGroupId":"3db39692-effc-4f2a-ba48-1accb1975f7e","PbiModelVirtualServerName":"sobe_wowvirtualserver","PbiModelDatabaseName":"e197d4d8-0139-4b49-b78a-3c054d890ca1"}]}

The GUID is highlighted above. This will correspond to the URL in your browser when you click on the correct dataset that is connected. 

https://app.powerbi.com/groups/me/datasets/e197d4d8-0139-4b49-b78a-3c054d890ca1