cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Azure SSAS tabular refresh issue

Hi,

 

Need help, I try to schedule refresh to my data set made by Import method from SSAS Tabular on Azure service. 

 

First I had error : Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

 

Then I try to use Edit Credentials option , Authentication method : Basic. After that I got another issue:

 

Failed to update data source credentials: We're sorry, an error occurred during evaluation.

Activity ID:14aae75d-705b-d7de-0b17-f3933949ce69
Request ID:87fdaeff-1d97-2023-8501-88e14a49dda9
Status code:400

 

Thank's for help !

6 REPLIES 6
Highlighted
Microsoft
Microsoft

Re: Azure SSAS tabular refresh issue

Hi @Marcin

I test the scenario as yours, when I publish Power BI Desktop file to Power BI Service, I  get the same error as yours. However, there is no Authentication method for me to choose, please check my screenshot.
1.PNG


But if I choose “Connect Live” to connect to Azure Analysis Service in Power BI Desktop, I can refresh the dataset in Power BI Service. Could you please check that if you are able to refresh dataset when using “Connect Live” mode  to connect to your Azure AS source?

 


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper V
Helper V

Re: Azure SSAS tabular refresh issue

When I connect to data model in Direct Query mode there is no need to refresh data, they are up to date all the time becouse of Live Connection. I need that report with Imported data to my Power BI model. 

Highlighted
Microsoft
Microsoft

Re: Azure SSAS tabular refresh issue

Hi @Marcin,

Please run fiddler trace and show us trace information.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper V
Helper V

Re: Azure SSAS tabular refresh issue

This time I have the same problem , I can't choose Authentication method:

 

issue.png

Highlighted
Microsoft
Microsoft

Re: Azure SSAS tabular refresh issue

Hi @Marcin,

I will report this issue internally and post back once I get any updates.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft
Microsoft

Re: Azure SSAS tabular refresh issue

Hi @Marcin,

I get information from PG that the feature( refresh model on Power BI Service with Azure AS data source in import mode) is not supported. This limitation will be documented in official article.

In your scenario, you would need to choose “Connect Live” to connect to Azure Analysis Service in Power BI Desktop and will be able to refresh the dataset in Power BI Service.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors