Error: This query contains transformations that can't be used for DirectQuery.

[HamidBee]

I am importing data from an Azure Serverless SQL db. 

 

I chose DirectQuery for this.

Here is the full SQL script that I used:

-- This is auto-generated code
SELECT
TOP 100 *, result.filename()
FROM
OPENROWSET(
BULK 'https://xxxxx.dfs.core.windows.net/taxi/raw/trip_data_green_parquet/year=*/month=*/*.parquet',
FORMAT = 'PARQUET'
)
WITH (
VendorID INT,
lpep_pickup_datetime datetime2(7)
) AS [result]

 When loading the parquet file....

I get an error which reads:

"This query contains transformations that can't be used for DirectQuery."

Strangely, it works perfectly fine with Import Query. Why do I get such an error with DirectQuery?.

[v-yalanwu-msft]

Hi, @HamidBee

 restart Power BI, then copy and paste the old query into a new one, and delete the old one, it should refresh fine.

Reference:

DirectQuery errors on imported tables. July 2018 C... - Page 3 - Microsoft Power BI Community

Solved: this query contains transformations that can't be ... - Microsoft Power BI Community

 
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HamidBee]

This answer is outdated. The composite mode is no longer in preview. I am currently using the June 2022 version of Power BI. Please update your answer. Thank you.