Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi, this is a great feature - but after months developing for my org using the feature, I am suddenly getting errors when refreshing which is jeopardising my entire project:
I have only found one thread on this issue, here: https://community.powerbi.com/t5/Desktop/Refresh-Failed-file-pfoledbreader-cpp-line-836-function/td-p/2882616
with users positing that MS have removed the ability to create calculated tables on DQ data, or on using certain calculated table functions on DQ data (e.g. I am creating calculated tables on DQ tables using FILTER (with || OR conditions), CALCULATETABLE, and other DAX. All of this worked fine earlier this year, yet it now fails despite the model not changing.
Please could someone confirm what MS have changed to invalidate the methods I've been using - it's very frustrating and currently my only option is to convert all of these data models to 100% import, which will mean a huge amount of time wasted. Thanks!
Have you raised a support ticket? It may be just a bug in the release. Documentation hasn't been updated to reflect a change in desktop Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn
I understand it isn't helpful for you right now, however, I specifically don't build production solutions using preview features, or am prepared to 'fix it', due to this disclaimer.