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.
no one has this problem?