Forum Discussion

fmunita's avatar
fmunita
New Member
4 years ago
Solved

Problem when public mi report

Hi,  I was playing with PowerBI desktop and I made my graphs connected to a DB that I have in Azure with DirectQuery, I save it and publish it to be able to see it in my work area of ​​powerBI web, but I don't see them upload the graphics. I get the following message.

My Azure database has a firewall that blocks the ips, I don't know if it will be that, because a message would appear that x ip does not have access.

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi fmunita ,

     

    I think the firewall will block the connection between Azure and Power BI.

    Notes:

    • Specify the fully qualified server name when connecting (see below for more details).
    • Ensure firewall rules for the database are configured to "Allow access to Azure services."
    • Every action such as selecting a column or adding a filter will send a query back to the database.
    • Tiles are refreshed every hour (refresh does not need to be scheduled). You can adjust how often to refresh in the Advanced settings when you connect.
    • Schema changes are not picked up automatically.

    For reference: 

    Azure SQL Database with DirectQuery

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi fmunita ,

     

    I think the firewall will block the connection between Azure and Power BI.

    Notes:

    • Specify the fully qualified server name when connecting (see below for more details).
    • Ensure firewall rules for the database are configured to "Allow access to Azure services."
    • Every action such as selecting a column or adding a filter will send a query back to the database.
    • Tiles are refreshed every hour (refresh does not need to be scheduled). You can adjust how often to refresh in the Advanced settings when you connect.
    • Schema changes are not picked up automatically.

    For reference: 

    Azure SQL Database with DirectQuery

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • fmunita's avatar
      fmunita
      New Member
      4 years ago

      Thanks, I'll review the documentation you gave me and I'll tell you how it goes.

      Greetings

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi fmunita ,

         

        Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.


        Best Regards,

        Rico Zhou