Forum Discussion
Dataflow Creation
Hi,
I'm trying to create a dataflow.
When I connect the server and insert my credentials this error coours:
I use same connection in Power BI Desktop and it works. When I published the app on Power BI Service I scheduled the refresh with same connetcion and it works.
Only when I create a dataflow with that connection it doesn't work.
The connection is "Azure SQL Database" Type.
Anyone can help me?
Thank you
Hi Gab_PowerBI
This may be because your Azure firewall is set to allow your IP address from your Desktop access to the SQL instance, but does not allow the IP address of the Power BI Service through.
There are a couple of things you can do on the Azure SQL server firewall.
The first one and easiest one is turning on the following option to allow other Azure services and resources through, which includes the Power BI service, (where the Dataflow is running).
The second one would be finding the list with all the ranges IPs for Power Bi Service. You can google azure range ip addresses. I think this link has them, but check it again just in case:
https://www.microsoft.com/en-us/download/details.aspx?id=56519
Hope this helps.
Stuart
2 Replies
Hi Gab_PowerBI
This may be because your Azure firewall is set to allow your IP address from your Desktop access to the SQL instance, but does not allow the IP address of the Power BI Service through.
There are a couple of things you can do on the Azure SQL server firewall.
The first one and easiest one is turning on the following option to allow other Azure services and resources through, which includes the Power BI service, (where the Dataflow is running).
The second one would be finding the list with all the ranges IPs for Power Bi Service. You can google azure range ip addresses. I think this link has them, but check it again just in case:
https://www.microsoft.com/en-us/download/details.aspx?id=56519
Hope this helps.
Stuart
can you share your connection details? are you creating it in the same workspace? This looks like its unable to reach it, maybe you have typed the wrong details in or if you in a different workspace that doesn't have access?
if you copy the power query code for the connection from your power bi file and paste it into a dataflow. Does that work? Provided its in the same workspace? I am assuming you have tested it already in the service and it works?
