what interfaces/properties should OLEDB provider support for DirectQuery in PowerBI Desktop?

[konst]

I created .mez file as wrapper for our OLEDB provider. Test connection and table data preview are working fine. However, when I click Load button in DirectQuery mode, PowerBI Desktop returns error "This query contains transformations that can't be used for DirectQuery".

I traced access to the internal interfaces in the OLEDB provider, and tried to understand whether some interface is not implemented correctly, or additional interfaces must be supported for the DirectQuery. Can someone tell which OLEDB interfaces are required for the DirectQuery, and if error occurs, where to get additional info? I turned PowerBI Desktop traces on, but those files do not contain sufficient information to resolve the issue. Pls help.

[v-juanli-msft]

Hi @konst 

OLEDB is not sopported to use direct query in power bi.

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Best Regards

Maggie

[konst]

would it be possible to request this feature (and have users vote for it)?

[v-juanli-msft]

Hi @konst 

It is possible for you to submit an idea in power bi Ideas forum.

https://ideas.powerbi.com/ideas/

Best Regards

Maggie