Forum Discussion
Refresh problem with composite model
Hello,
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?
3 Replies
- leewsRegular 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?
- collinqSuper User
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
- BirhanAYDSHelper III
Hi leews,
Try to create the calculated table in power query. It is limitation.