Trouble with LOOKUPVALUE() in DirectQuery: Need Guidance on Calculated Tables and Refresh Failures P

Hello everyone,

I need help solving an issue with PowerBI. I connected to a PowerBI dataset using 'DirectQuery' and realized that the LOOKUPVALUE() function is not allowed with tables in 'DirectQuery'. To work around this, I created a new table using ADDCOLUMNS() and SUMMARIZECOLUMNS() to import the necessary data. Now that my data is in 'Import' mode, I can use the LOOKUPVALUE() function as intended.

However, when publishing the report, I received a message stating: 'This dataset contains calculated tables or calculated columns that reference remote tables, resulting in refresh failures after publishing. Do you want to continue publishing?'

Have you encountered this issue before, and do you have any suggestions for resolving it?

Thanks in advance for your help.