Forum Discussion
Dataflow - Validating Queries FOREVER + Gateway issues
Hi Anonymous ,
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
Kelly
Hi v-kelly-msft
Thank you for the quick reponse!
1: Its an ODBC connection to Hive Database. We use the HortonWorks ODBC Drivers. There are no additional steps after reading the source. Since about 1 week, I am seeing this error message a lot
2. We are using the Enterprise Gateway. There is only one gateway which has not been changed. The error message you see has to do with permissions. I as an Gateway Admin can create Entities, however my team mates who are just Gateway Connection Users are unable to create Entities. However they are able to use the same connection to schedule their Datasets.
This issue was fixed by Microsoft in Septemebr 2019. But we are still experiencing this error message.
https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-september-2019-feature-summary/
- same here - multiple types of source systems (ODBC to HIVE/Hadoop, MS SQL Server, etc.) - enterprise gateway, P1 capacity, have been using dataflows for a long time with great success. Now recently, these problems are preventing me from making several needed updates...