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. S...
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 🙂

venal's avatar
venal
Memorable Member
6 years ago

Anonymous 

Can you please share the error message.

 

How was the behavuour if you use the Import mode, can you please try to re-pro for testing purpose and update us.

 

If you have any concerns, please let us know.

 

BR,

venal.

martijnth's avatar
martijnth
Helper II
6 years ago

In manage gateways alls works fine.

 

Show details gives:

and

screen dump of gateway:

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 🙂

  • martijnth's avatar
    martijnth
    Helper II
    6 years ago

    Dear Shayeny,

    this has actually solved a long and lasting challenge. I have no clue how you found out, but you are my hero!

    many many thx.

    reg Martijn

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    martijnth 

    Thanks for posting the details with the error message.

    Can you please confirm the same with the Import behaviour, Is it working or getting any error.

    If it is issue with the only the "Direct Query", please submit a support ticket to investigate.

    Please share the support ticket number here for reference.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more
    If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

     

    BR

    venal.

     

  • martijnth's avatar
    martijnth
    Helper II
    6 years ago

    Dear Venal, 

    I understand the question, however time does not permit me.

    reg martijn