Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
75 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |