Forum Discussion
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, b...
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
