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?
Hi @leews,Try to create the calculated table in power query. It is limitation.
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
Proud to be a Datanaut! Private message me for consulting or training needs.
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!