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 be able to nail it back to the exact report.
5 Replies
Could you please specify a bit more. You can't connect to the report, you may connect to Power BI dataset or Power BI dataflow ( in recent Excel). Assume you have connection to dataset (Data -> Get Data -> From Power BI). With it you may create PivotTable in Excel. In general result is exactly the same as if use Analyze in Excel - you connect to dataset and build PivotTable based on it. The only difference is entry point to dataset.
Power BI report is built on same dataset, but you can't reproduce it in Excel literally. With that, what is exact task, what you'd like to trace?
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.
