Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an instance of Azure AS up and running. My aim is quite simple: To import some of the Metadata into PowerBI Desktop.
Example:
select * from $SYSTEM.TMSCHEMA_COLUMNS
When I connect to AAS in DirectQuery mode, there's no problem.
However, when I attempt to import the results of the above query, I get the the error message "We couldn't authenticate with the credentials provided. Please try again".
My steps are:
1. Configure connection, query mode, and query text
2. Authenticate using the Microsoft Account. PowerBI confirms the Microsoft-Account authentication.
3. When I select the Connect button, I get the mentioned error message
The strange thing is, when I use DaxConnect, I can connect and execute the above query.
What do I have to do to convince PowerBI to allow me to query Azure AS?
Solved! Go to Solution.
This seems to have been a bug in PowerBI. I upgraded to the October 2019 version, which solved the issue.
Try to clear permissions in data source settings and also check the database name.
This seems to have been a bug in PowerBI. I upgraded to the October 2019 version, which solved the issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |