Forum Discussion
Trace connection from Excel back to Power BI
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.
- 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
