Problem when public mi report

[fmunita]

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

[Anonymous · Accepted solution]

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]

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

Greetings

[Anonymous]

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

[fmunita]

yes i got the connection thanks

[fmunita]

no one has this problem?