Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
Dear @Greg_Deckler thanks for the reply but unfortunatly I didn't undertsand what to do.
Could you give me additional info?
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.
@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"}]}
{"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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |