Forum Discussion
gateway connection problem with Dremio connection
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 🙂
Hi Martijn,
Quick question: after applying the gateway creation, did you also go to the Users tab and did you add your user (or any other user that wants to publish with this datasource) there?
Nicky
Hi Nicky,
not sure exactly what you mean with Users, if you mean Share, then yes, the report has been shared automatically. The funny thing is that it also seems to refresh, while this setting is not even accessible! I am lost
Ah, your picture threw me off a little there, but I now see this is the Cache Refresh history..
So this means this is when the cache for the DirectQuery part is refreshed in the service. :)
And according to your schedule this is set to refresh every hour. You can configure it up to every 15 minutes.
Martijn,
with the Users tab I meant this part in the Data Gateway setup:
You'll have to assign users to the gateway entry to be able to setup Scheduled Refresh.
Strange that your dataset is automatically refreshing. You can check who has set it up if you go to the settings of the dataset in the workspace. You should be able to see a login name there.
Hi Nicky,
all created by myself, i never actually touched the Users tab, I guess I never ran into this before.
However with the Users my name is there, in all my other connections the Local IT name is there, so I added local IT , but no change
reg martijn
still not able to see the F%$# report