Issue - Power BI Dataflow - Validating Queries - Extremely, Extremely, Extremely Slow

Hi, MartinMason 

Question 1:

Which kind of data sources does the dataflow get data from? Is there any specific features made to the entity, eg: Merge/Append queries? 

Question 2:

There are a few known limitations to using Enterprise Gateways and dataflows:

• Each dataflow may use only one gateway. As such, all queries should be configured using the same gateway.
• Changing the gateway impact the entire dataflow.
• If several gateways are needed, the best practice is to build several dataflows (one for each gateway) and use the compute or entity reference capabilities to unify the data.
• Dataflows are only supported using enterprise gateways. Personal gateways will not be available for selection in the drop down lists and settings screens.

So it requires to assign an administator role of the gateway to others once you want them to add entities to the dataflow.

Here is the reference.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-on-premises-gateways

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET" to get further help.

Best Regards,

Community Support Team _Charlotte

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