cancel
Showing results for 
Search instead for 
Did you mean: 

PowerBI Report Builder - Error message when trying to Connect to Analysis Services

Hi,

 

I'm currently trying to build a paginated report using an analysis services model as a data source.

 

When I create the Data Sources connection there isn't any errors thrown. When I go to create a data set and attempt to open the query design I'm faced with the following error:

 

"Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials."

 

Has anyone experience a similar issue?

Status: Investigating

Hi,

Have you tried to follow the suggestions in the error message to remove the user name and password from the connection string, and then retry.

 

Whether there is the detailed error message in refresh history or gateway settings when refresh failed, you can click 'Show details' in these panes to find it.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

Hi,

Have you tried to follow the suggestions in the error message to remove the user name and password from the connection string, and then retry.

 

Whether there is the detailed error message in refresh history or gateway settings when refresh failed, you can click 'Show details' in these panes to find it.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin