Connect a Shared Report to a DataFlow?

[PatrickMcLeanGL]

Is there a way to connect a Power BI Report shared to me by another tenant to my own Dataflow so I can have it synced automatically every day on my end when the report updates and manipulate the data in my own way?

[PatrickMcLeanGL]

Unfortunately, they will not give me direct access to the data source.

Can I use Power Automate to download the report and automatically dump the data into my own data source?

[v-yifanw-msft]

Hi @PatrickMcLeanGL ,

Based on the information you've provided, your ability to synchronize report updates and manipulate the data in your own way depends on whether you have access to the underlying data sources or shared data sets.

You need to request access from the report owner or data owner. Create data flows in your own workspace to import and transform data as needed. Then set up Scheduled data flows to refresh automatically to ensure that your data is up to date. Achieve synchronized updates.

It's worth mentioning that if the data source is a dataflow, you must use the API to set this up. I recommend you read the following link to accomplish your purpose:

How to Use Dataflow to Make the Refresh of Power BI Solution FASTER! - RADACAD

Power BI Dataflow refresh polling | endjin - Azure Data Analytics Consultancy UK

If you encounter any problems during setup, you can provide an error message or screenshot of the error you encountered.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[aj1973]

Hi @PatrickMcLeanGL 

If your Dataflow has the same exact structure then it might be possible.