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.
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.