Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @Fernandamrl,
In your scenario, you are trying to connect Power BI to Azure SQL Server. However, it returns an error. Right?
First, what's the version of your Power BI Desktop? You can verify this under File -> Help -> About.
Then to troubleshoot your issue. You can try following method:
1. If you have ever connected to Azure SQL database in Power BI Desktop, I would recommend you go to “File –> Options and Settings –> Data Source Settings”, under “Global permissions”, select any old Azure SQL data source connections and click on clear permission. Then re-connect to Azure SQL database from Desktop, also enter database name during the connection.
2. Please ensure that you have set up a firewall rule to allow Power BI Desktop to make a connection to Azure SQL.
Thanks,
Xi Jin.
Hi @Fernandamrl,
In your scenario, you are trying to connect Power BI to Azure SQL Server. However, it returns an error. Right?
First, what's the version of your Power BI Desktop? You can verify this under File -> Help -> About.
Then to troubleshoot your issue. You can try following method:
1. If you have ever connected to Azure SQL database in Power BI Desktop, I would recommend you go to “File –> Options and Settings –> Data Source Settings”, under “Global permissions”, select any old Azure SQL data source connections and click on clear permission. Then re-connect to Azure SQL database from Desktop, also enter database name during the connection.
2. Please ensure that you have set up a firewall rule to allow Power BI Desktop to make a connection to Azure SQL.
Thanks,
Xi Jin.
@v-xjiin-msft I'm using SQL Azure, Can you help me find some reference on how to Allow PowerBI desktop as you mentioned.
Olá,
Problema solucionado!
Resolvi excluindo e recriando todas as minhas conexoes de fontes de dados e reisntalei o Power BI Desktop.
Obrigado!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |