Forum Discussion
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...
SergeiBaklan Thanks very much for your response. The issue is that we have recently changed tenancy. And I will like to point the excel files to the new tenancy. I have published all the power bi files from old tenancy to the new tenancy but the excel files that depend on the old tenancy, I can't figure out which power bi report my predecessor created the excel file from. If i knew what the reports are i will go to power bi in the new tenancy and download analyse in excel copy the connection string from the newly downloaded and change the existing excel to use that connection string from the newly downloaded excel
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.
- 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