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

[Pjutgg]

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.

[amitchandak · Accepted solution]

@Pjutgg , In Direct query you have limitations on what you can use column/measures, Especially columns.

Across tables, you are only allowed to use DAX function Related. Rest you are not.

Direct Query - End to End (Connection to Publish): https://youtu.be/cf-YNWX8Qow

[Pjutgg]

Hey Amitchandak, 

Thanks for your help. I will check that right now 🙂