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.
Hi!
DirectQuery is not working on PowerBi Service. But it does work on PowerBI desktop.
Is this on the roadmap or already scheduled to release as this feature is available in PowerBi Desktop.
When can one configure a PowerBi Gateway to use DirectQuery with Postgres?
There is an open source connector https://github.com/sgoley/DirectQuery-for-ODBC-in-PowerBI for this, but I've yet to test it.
Anyone tested that ^?
Solved! Go to Solution.
Hi @kunde13 ,
>>DirectQuery is not working on PowerBi Service. But it does work on PowerBI desktop.
In my opinion, I'd like to suggest you take a look at following links about create a custom connector to enable direct query connection mode.(it include detailed steps and sample formula)
Enabling direct query for a data source via an odbc driver
DataConnectors/m-extensions#next-steps
BTW, please don't forget to enable custom connector support on your gateway.
Use custom data connectors with the on-premises data gateway
Regards,
Xiaoxin Sheng
Hi @kunde13 ,
>>DirectQuery is not working on PowerBi Service. But it does work on PowerBI desktop.
In my opinion, I'd like to suggest you take a look at following links about create a custom connector to enable direct query connection mode.(it include detailed steps and sample formula)
Enabling direct query for a data source via an odbc driver
DataConnectors/m-extensions#next-steps
BTW, please don't forget to enable custom connector support on your gateway.
Use custom data connectors with the on-premises data gateway
Regards,
Xiaoxin Sheng
Hey,
thanks for the input.
Today an update for the gateway was released which includes support for DirectQuery on the gateway.
So my problem is gone 🙂
Thanks!
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.