Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Refresh problem with composite model



I'm having an error message when trying to refresh composite models on the Service. The composite models have similar structures:

Dataset (has many tables with 1 calculated table) and 2 connections with dataflows, but one of them has one more calculated table to RLS.


When trying to refresh, receive the following error message:


Looking at the credentials, all looks fine.


I don't use gateways, since there is the following message:


Tryied with RLS and without on both composite models, but with no success.


Can anyone help me please?

Helper II
Helper II

Hi @leews,

Try to create the calculated table in power query. It is limitation. 

Regular Visitor

Making more tests, I tryied updating without the calculated table and the refresh worked on the service.

Do you know if there is a way to make this refresh work, even with a calculated table on the composite models?

Hi @leews ,


I am wondering if this is the issue that you are running into?  Look at the Considerations and Limitations section?  Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.

Helpful resources

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!


Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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

Top Kudoed Authors