direct query + excel refresh issue

Hi juju63 

Thanks for the reply from djurecicK2  and SaiTejaTalasila , please allow me to provide another insight:

According to your error code “This dataset contains calculated tables or calculated columns that reference remote tables”. This indicates that you have encountered a restriction on the calculated table or calculated column that references a remote table.

Did you connect to the dataset in direct query mode in Power BI Desktop and then create the calculated table?

If so, could you please check to see if a calculated table was created in it? Calculation tables are an import mode that can cause refresh failures.

Also you can check if you meet another limitation in this:

Solved: Composite Models using Power BI datasets, Calculat... - Microsoft Fabric Community

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

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