Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
konst
New Member

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

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.

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

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

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

Hi @konst 

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

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

 

Best Regards

Maggie

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.