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
Please can you help me create my first dataflow from a SQL table.
I have done the following:-
Ok, so now I know everything is working ok I want to create my first SQL dataflow.
Source = Sql.Database("123.456.7,89,4321", "Testdata", [CreateNavigationProperties=false]),
dbo_Products = Source{[Schema="dbo",Item="Products"]}[Data]
in
dbo_Products
What am I doing wrong?
Why cant it find my On-premises data gateway (personal mode)?
Please can you provide detailed instructions because this is my first time using sql dataflows.
Many thanks
Solved! Go to Solution.
Hi @speedramps ,
Dataflow will not work with a personal gateway. If you have a personal gateway, you may like to consider uninstalling it and installing the enterprise version instead. See more about install and setting for the enterprise gateway : What is an on-premises data gateway?.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @speedramps ,
Dataflow will not work with a personal gateway. If you have a personal gateway, you may like to consider uninstalling it and installing the enterprise version instead. See more about install and setting for the enterprise gateway : What is an on-premises data gateway?.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, but that is not the answer.
I have just read "Dataflows are only supported using Enterprise Gateways."
I am using an On-premises data gateway (personal mode) !
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-on-premises-gateways
I will try set-up and use Enterprise, unless anyome knowd a workarround on how to create a SQl dataflow without a Enterprise Gateway
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.