Microsoft are increasingly trying to get users to store data in Fabric and then access them from other sources, be it Power BI or Excel. It's great to be able to do this, but the problems come when you can't remember where you got the data from. How can you work your way back to that?
Excel is particularly unhelpful in this respect if you have a connection direct to a table on a tab in the front end (i.e. not going via Power Query). You can click on the relevant connection in the Connections window (Data/Queries and Connections) but then it's remarkably coy about finding anything else.
I have figured out the way to find your way back.
1. Right click on the relevant connection and choose Properties
2. Click on the definition tab. The information you need is in the "Connection string" window.*
3. The key bit of text you need is called the "datasetID". This is the long string that will be something like: 842gh54e-1567-56b9-jklt-52375621321g. I don't know how much the text varies in this box, but for the ones I'm looking at it comes after "wowvirtualserver-" under "Catalog"
4. Once you have the datasetID you can drop it into this url:
https://app.powerbi.com/onelake/details/dataset/<DatasetID>/overview?experience=power-bi, so in this case:
https://app.powerbi.com/onelake/details/dataset/842gh54e-1567-56b9-jklt-52375621321g/overview?experience=power-bi
This takes you through to the Onelake page for the dataset which has the Dataset (Semantic model) name in the top left and the Workspace name a little under that under "Location".
Thus is you need to make changes, want to see how often it refreshes, or just work out where it's coming from.
*There is also the "Command text" window here, which gives you details of the DAX used to create the Excel table)
No comments:
Post a Comment