Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I'm trying to access my SQL data on Azure and get this message each time. This worked before with the same credentials, but now stopped literally overnight. I can access the data through SSMS. Any idea what could be the problem?
I had the same problem yesterday,
What the problem was:
My database (also sql) refreshed on mondaymorning 09:00, when the database refreshed, i lost connection with this database.
So they needed to give me permission to access the database, it seems that they have to do it every time the database refreshes.
Maybe this helps you out
We spoke to Microsoft, who suggested that we run Power BI as an administrator and connect to Azure SQL as an administrator while they look into this issue.
Check if the following link helps.
https://community.powerbi.com/t5/Issues/SQL-connect-error/idc-p/248557#M14421
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 50 | |
| 44 | |
| 42 | |
| 19 | |
| 19 |
| User | Count |
|---|---|
| 70 | |
| 68 | |
| 33 | |
| 32 | |
| 32 |