Forum Discussion
Refresh not supported in Direct Query with Field Parameters
The only option I had in mind was to move all the measures into the Semantic Model.
To keep things organized and manageable, I used Folders within the model. Additionaly, I created Parameters in the Semantic Model to support dynamic filtering and logic.By doing this, we also enable a live connection, which allows real-time data refresh and interaction.
At this point, this seems to be the most practical and scalable solution.
Hi muneeba It might be because Field Parameters in DirectQuery mode are not fully supported for scheduled refresh, leading to errors post-publish. You could try replacing Field Parameters with calculated columns or measures that dynamically update based on the current year. Ensure these calculations are performed within the semantic model or use DAX expressions that are compatible with DirectQuery to maintain refresh functionality.
The challenge is that I need measures displayed as columns in a Table, with dynamic column headers like "Premium 2025", "Premium 2024" based on current and previous year. As far as I know, calculated columns or measures alone can't create dynamic column names in a visual.
Is there any workaround to achieve this while keeping the model fully in DirectQuery?
Alternatively, would it make sense to move the measures and parameter table into the semantic model itself, so I can use a live connection in the dashboard PBIX instead of DirectQuery? Open to suggestions if there's a cleaner way.
Dynamic column headers aren’t natively supported in DirectQuery, so you could use static placeholders ("Current Year" and "Previous Year") with dynamic content or tooltips to clarify the year. You could also look into custom visuals or paginated reports can handle this better. Moving measures and parameter tables to the semantic model allows switching to a live connection, fully supporting Field Parameters and eliminating refresh issues.
The only option I had in mind was to move all the measures into the Semantic Model.
To keep things organized and manageable, I used Folders within the model. Additionaly, I created Parameters in the Semantic Model to support dynamic filtering and logic.By doing this, we also enable a live connection, which allows real-time data refresh and interaction.
At this point, this seems to be the most practical and scalable solution.