Fetching data from multiple microsoft platform

[ghouse_peer]

Hello Guys,

I have an issue, One of my friend is already working on a PBI report. Data source is excel which is uploaded in Microsoft teams. So he has downloaded the files to his PC and generated the report and uploaded the PBIX file into Microsoft Teams.

So my issue is how can i work/continue to generate the report from the same PBIX file.

If at all i download the PBIX file and start to work, how come the current results reflect in the report because the data for the PBIX file is present in my friends PC.

Note: The excel data will be updated only in MS Teams.

Kindly let me know the process/Solution to work on the same file.

Thanks in advance...

[amitchandak]

@ghouse_peer , In case you want to share data model. You can publish Pbix and use that as the source file. Now model will remain the same and you can create visualization and merge it using copy paste

[Mariusz · Accepted solution]

Hi @ghouse_peer 

I imagine your file is located in SharePoint location, so you can create a Power Bi report that links directly to this file and use Power Automate to Refresh the dataset as per below.

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn