Forum Discussion
Refresh not working due to DirectQuery source and calculated table
Hi afaro ,
Thank you for reaching out to Microsoft Fabric Community Forum. Also thank you lbendlin for your inputs.
The error you're encountering occurs because the dataset includes calculated tables or columns while also using semantic models (datasets) as DirectQuery sources. This combination is currently not supported for refresh operations in the Power BI Service.
Calculated tables are evaluated during dataset refresh, but datasets that connect to other semantic models via DirectQuery cannot perform these evaluations during service-side refresh, which leads to the failure you're seeing.
To resolve this, you can either avoid using calculated tables and instead implement the logic using measures or visuals, move the summarization logic upstream into the source semantic models, or switch to importing the required tables if the calculated table is essential. We understand the goal of maximizing model reuse, and we're happy to help you rework the model structure based on these supported patterns.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
Hi afaro ,
Thank you for reaching out to Microsoft Fabric Community Forum. Also thank you lbendlin for your inputs.
The error you're encountering occurs because the dataset includes calculated tables or columns while also using semantic models (datasets) as DirectQuery sources. This combination is currently not supported for refresh operations in the Power BI Service.
Calculated tables are evaluated during dataset refresh, but datasets that connect to other semantic models via DirectQuery cannot perform these evaluations during service-side refresh, which leads to the failure you're seeing.
To resolve this, you can either avoid using calculated tables and instead implement the logic using measures or visuals, move the summarization logic upstream into the source semantic models, or switch to importing the required tables if the calculated table is essential. We understand the goal of maximizing model reuse, and we're happy to help you rework the model structure based on these supported patterns.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
Hi afaro ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.