Forum Discussion
Helper IIAnalyze in Excel
Community SupportHi TheCreepster1 ,
All shared data source information in the tenant is located as follows, you can find the corresponding dataset and check its administrator and ask for the source of its excel data.
Or you can view similar solutions.
Solved: How to use an Analyze in Excel pbiazure in a separ... - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TheCreepster1Hi Henry, thanks for your reply. Unfortunately this doesn't help solve what I am after. One of my colleagues has given me an excel workbook that has a connection in it to a Power BI dataset. What I am trying to do is identify which dataset this has come from so I can then go into the construction of this dataset in the back end. All I have in the excel workbook is the connection name and connection string in the Connection Properties screen, and from this information I can't easily identify which Power BI dataset it links to.
In the connection name I have (masked with x):
pbiazure://api.powerbi.com xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Model
And in the Connection String (masked with x):
Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver-xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;Update Isolation Level=2
From this information, is there a way I can then go identify which Power BI dataset this has come from?