How to export Power BI Dataflow to Dataverse?

[averylesser]

Hi everyone! The buzzword at my company seems to be dataverse, and with that, everyone seems to want all data in Dataverse rather than in a Power BI Cloud-services dataflow. I google'd but could not find answers:

1) Is there a way to import data from Power BI Cloud-Services dataflow into a Dataverse domain?

2) If not, what is the advantage of putting data into a Power BI Cloud-Services dataflow rather than Dataverse so that Power Apps can easily access it?

Thank you!

[v-kkf-msft]

Hi @averylesser ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @averylesser ,

Dataflows enable you to connect with business data from various sources, clean the data, transform it, and then load it into Dataverse. Please refer to these documents to add data to a table in Dataverse by using Power Query.

https://docs.microsoft.com/powerapps/maker/data-platform/import-export-data 

Add data to a table in Microsoft Dataverse by using Power Query 

Dataverse Synapse Link to Data Lake Storage integrated with Power BI Desktop and Dataflows 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @averylesser 

As far as I know right now it is not possible to export from Power BI to Dataverse

I would say the advantage using the dataflow is that the data is stored in an Azure Container, which means other Azure services could access this data. If you then had to use the enhanced compute engine you could then get super fast query performance from your dataflows.