Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
HI,
I'm building PowerBI model with composite model.
There are some table that's in import mode, and some which are DirectQuery.
I created calculated column on the imported table to perform value lookup from DirectQuery table.
But the column only refreshed when I made dummy changes on the formula.
I can't refresh the calculated column value no matter what I do.
The use case here is User are performing data mastering on a tool.
The DirectQuery table purpose is to allow us to get the latest mastered value from the tool into the imported table.
We can't convert the DirectQuery to Imported mode as the table refresh frequently.
On the other hand we can't switch the Imported table to DirectQuery because of the complex and large dataset.
Related community thread discussion: https://community.powerbi.com/t5/Desktop/PowerBI-Direct-Query-amp-Cache/td-p/1303518
Raised Microsoft Support Ticket: 120082226000045
None of them give me good answer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.