Forum Discussion

Gab_PowerBI's avatar
Gab_PowerBI
New Member
3 years ago
Solved

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 ...
Need Help
  • Burningsuit's avatar
    Burningsuit
    3 years ago

    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

Burningsuit's avatar
Burningsuit
Resident Rockstar
3 years ago

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