Forum Discussion

martijnth's avatar
martijnth
Helper II
6 years ago
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. So the first error when opening  the report is shown below:

 

the when we follow the link we get:

 

We manually added the gateway, we followed the option in the menu and get:

So basically we made connection, but still, the report is not working. We keep getting the message 'not configured correctly'. Please share your thoughts we are out of ideas.

 

reg martijn

 

 

 

 

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    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 🙂

23 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    6 years ago

    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

    • martijnth's avatar
      martijnth
      Helper II
      6 years ago

      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

       

       

       

      • nickyvv's avatar
        nickyvv
        Most Valuable Professional
        6 years ago

        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.

         

  • quangbilly98's avatar
    quangbilly98
    Frequent Visitor
    1 year ago

    To anyone who encounters the same problem, besides the anonymous answer, you should also check the "Name" of the DataSource inside Power BI Desktop.

    It should have ":port" in it like below

     

    Somehow, when creating a Dremio Software connection, my Power BI just removes the port part in the name. In the Desktop, it works fine, but when published to the Web Service, it gets the same error as the author. I have to manually add the port part in the Advanced Editor in Power Query.

    I think this is some kind of error from the PowerBI/Dremio dev side.