Forum Discussion
Multiple connections to dataverse
I am using oData connection to my dataverse environment (I am not using the dataverse connector as I need more metadata only the oData provides
https://orge????.api.crm.dynamics.com/api/data/v9.2/EntityDefinitions
1. 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 entitiy
2. 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?
2 Replies
- v-kelly-msftCommunity Support
Hi kobia10 ,
You could create a dataflow first,check the reference below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- kobia10Microsoft Employee
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.