Refresh problem with composite model

[leews]

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?

[BirhanAYDS]

Hi @leews,

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

[leews]

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?

[collinq]

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