Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody,
I am trying to get a dataflow load data from a data source which is provided via on premise gateway.
I have registered the data source in power bi service with a succesfull connection test.
When I create a new dataflow querying a single table from this data source via the on premise gateway I get the error below:
I am sure the server name and database name in power query match the ones configured in the data source of the gateway.
For testing purposes I created a Power BI file querying the same data source.
After publishing to Power BI service I connect the dataset to the on premise gateway.
Everything works fine and I can refresh the dataset.
Is this a bug in dataflows or anyone knows what could be the reason of the error?
Thanks!
Marc
Solved! Go to Solution.
I found out the issue, you can't use multiple gateways within the same dataflow.
I created a separate dataflow and then I was able to choose a different gateway for the entity.
Kind regards,
marc
Hi @Marc1979 ,
Can you confirm you are choose the correct gateway or you have permission to access that gateway? Can you please share more detail information to help us clarify this scenario?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I found out the issue, you can't use multiple gateways within the same dataflow.
I created a separate dataflow and then I was able to choose a different gateway for the entity.
Kind regards,
marc
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.