Dataset as a source for Dataflow.

[Anonymous]

Hi,

I've few Datasets which I need to use in my existing report. How to achieve this?. When I try to connect I get below error message.

How to connect Datasets with my existing reports?  

I tried with creating Dataflow, but here I can't use source as a Dataset. I'm kind of struck here. Please help me on this. thansk!

[Anonymous · Accepted solution]

Hi,

I've achieved this by different approch like Created a Paginated Report with simple table and published next I used Power Automate Flows to export a XLSX file into Sharepoint folder. 

So In the mean time i Use this approach to get this done. Thanks for you reply. 

[MFelix]

Hi @Anonymous ,

the connection to Power BI datasets is a live connection, so has the error messages tells you cannot connect to more than one dataset at the same time in the same report.

What is the purpose of this multiple datasets connection? 

You want to create a new report that shows information from the datasets but in and independent way, having a visualization for each dataset? Or do you want to make comparable information?

Be aware that there are some features that allow you to interact between different reports / datasets without the need of creating one report that agregates all for example the creation of an app that can includes pages from different reports and the drill trough that can be enable between different reports also.