Forum Discussion
Solved
gateway connection problem with Dremio connection
Dear Reader, we have setup an SAP - Dremio - PBI connection that works well in Desktop environment. When we publish it is not working, other published reports are running fine in the Service mode. S...
Hi martijnth,
I managed to get my PowerBI - Dremio direct query working 🙂
For me, it wasn't an issue with the connection, but rather with the way the data was being pulled into to power bi!
When you use the UI to "Get Data", you go through multiple steps in power bi to access the Virtual Dataset on Dremio. This results in 2 or 3 steps in the Power Query Editor - one to access the source, and the next to access the table.When you click on the "Source" step, power BI actually shows the issue;And this is the resulting query in the Power BI Advanced Editor.
How I corrected this was by changing the Advanced Query to directly call the table in the first step itself.. and now Direct Querying on Power BI service works !!!
Also, another point to note is that the data source name should be the same on Power BI Desktop & the On-premise gateway. It needs to be either "host" or "host:port" on both ends...
Let me know whether this works for you as well 🙂
Worked for me also .