Forum Discussion

Copper Contributor

Dec 10, 2021

Trace connection from Excel back to Power BI

There is a power connection in my excel workbook. I want to be able to trace what reports the connection was generated from in power bi. I am sure my predecessor used analyze in excel but I want to b...

excel

power bi

SergeiBaklan

Diamond Contributor

Dec 10, 2021

abimfol

Connection string uses dataset ID, not its name. I'm not sure how to find ID, sorry. That's better to ask Power BI community.

abimfol

Copper Contributor

Dec 10, 2021

SergeiBaklan thanks very much. Your response actually helped me to know what to look for. The below blog was useful in how to find dataset id

https://www.cathrinewilhelmsen.net/how-to-find-dataset-id-power-bi/

Thanks once again

SergeiBaklan
Diamond Contributor
Dec 11, 2021
abimfol , glad it helped.

Thank you for sharing the blog, perhaps will need this knowledge one day.