Local model using Direct Query for Azure Analysis Services not refreshing using Power BI service.

[Anonymous]

Hello,

Our team is using Azure Analysis Services, normally we were using Live connection, but the Live Connection model was not able to be used in online Excel as a data source.
By changing the model to Direct Query we managed to resolve that issue, but we ran into a new one.
When we update the .bim model file in AAS, like adding a new column of a table that is selected in the Local model, the new column is not visible in the Semantic model in the service.
If I refresh the semantic model in the service, nothing happens, yet when I refresh the model when I download the Semantic model in the Power BI Desktop app, it does.
Is this some sort of limitation?

Thanks in advance.

[Anonymous]

Hi @Anonymous ,

You have changed the data in the .dim file on the local end, you need to upload it to the service again, or configure a schedule to refresh the semantic model reports can change.

Due to Direct Query limitation:

After a report is published, Refresh in the Power BI service refreshes the visuals in the report. But if the underlying source schema changes, the Power BI service doesn't automatically update the available fields list. If tables or columns are removed from the underlying source, it might result in query failure upon refresh. To update the fields in the model to reflect the changes, you must open the report in Power BI Desktop and choose Refresh.

Below is the official link will help you:

DirectQuery in Power BI - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

Sorry if I wasn't clear enough, I meant refreshing the semantic model not the visuals, the problem is that the scheduled refresh doesn't do anything (PBI service)

But, the refresh in the Dektop app works.