Multiple connections to dataverse

Question

I am using oData connection to my dataverse environment (I am not using the dataverse connector as I need more metadata only the oData provideshttps://orge????.api.crm.dynamics.com/api/data/v9.2/EntityDefinitions1. I see in diagnostics that 10s of queries are ran against the environment instead of only the one I have created. Seems that PQ decides to run a query at least per entitiy2. I have 10 queries, all based on the Source query and I see the above look being generated 10 time, that is, I get at the end 10*10s queries to the remote data source. is there a way to have the main query be reused?&nbsp;

v-kelly-msft · Answer

Hi&nbsp;kobia10&nbsp;,
&nbsp;
You could create a dataflow first,check the reference below:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-odata-dataflows-migration
&nbsp;
Best Regards,Kelly
Did I answer your question? Mark my post as a solution!

kobia10 · Answer

I am trying to create a PBI that can be easily used by partners\SI's with minimum dependencies as possible. currently i require only the environment as parameter. encorporating dataflow into it will make it more complex.

Forum Discussion

Related content

Missing Connection Details - Dataverse

Connectivity Issue : Power BI to dynamics 365 (Dataverse)

How to connect multiple Dataverse on a report

Managing multiple environments with dataverse connections

Mirrored Dataverse in Fabric