Azure AS Import Connection Problems

[gjvanvuuren]

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

Cube Metadata Query

2. Authenticate using the Microsoft Account. PowerBI confirms the Microsoft-Account authentication.

Cube MS Account Login

3. When I select the Connect button, I get the mentioned error message

Cube MS Account Error

The strange thing is, when I use DaxConnect, I can connect and execute the above query.

DaxStudio Cube Connect

What do I have to do to convince PowerBI to allow me to query Azure AS?

[v-chuncz-msft]

@gjvanvuuren 

Try to clear permissions in data source settings and also check the database name.

[gjvanvuuren · Accepted solution]

This seems to have been a bug in PowerBI. I upgraded to the October 2019 version, which solved the issue.