Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Workflow using the On-Premise data gateway and ODBC

My situation in short.  I've got multiple databases on servers scattered around the country.  I'd like to use this data from these locations to make a single report (for example) and give my compan...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    10 years ago

    As i suspected the actual solution to my problem was very simple. 
    The DSN needs to be the same on the gateway and the client from where the dataset is published. 
    Very logical in hindsight. Topic can be closed.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thanks for your reply again. I took a look at the url you included and had indeed already read it. 
It didn't help me out much in understanding how i am supposed to get to my data from my different sources. 

 

According to what you said before, I can't use power bi desktop in combination with the on-premise data gateway. 
So i'm not sure how to proceed from here. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      This made things even more unclear. 
      I've already set up the on-premise data gateway. In app.powerbi.com it says everything is fine and connected. 
      I havn't published any reports from powerbi desktop. 

      In app.powerbi.com there are no datasets showing up and under the Get Data button there is no option to collect data from a gateway. 

      Am i correct in assuming a dataset should show up once a data gateway connection is established?

      Or do i actually have to make a pbix file from Power Bi desktop and publish it, and somehow the data gateway can update this published dataset? I've read something about naming a pbix file in a certain way..

       

      I have no clue whatsoever :(... 

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Hi Anonymous,


        Am i correct in assuming a dataset should show up once a data gateway connection is established?

        No, once you have installed the On-premises Data Gateway, you will still need to add data sources that can be used with the gateway. After you have created the data source, it will be available to use with either DirectQuery connections, or through scheduled refresh. Please refer to this article to add all your data sources to your gateway first.

        Or do i actually have to make a pbix file from Power Bi desktop and publish it, and somehow the data gateway can update this published dataset? I've read something about naming a pbix file in a certain way..

        In your scenario, yes, you will need to make a pbix file, and get data from all your data sources(we can get multiple data sources to a single dataset with Power BI Desktop), and build your reports from Power BI Desktop, and publish it to Power BI service. Then the data sources you have added to your gateway can be used for scheduled refresh in this case.

         

        Regards