Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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 company some insight into this data. 


I've only managed to build reports with Power Bi Desktop using an ODBC connection from a database in the local network. This proces was quite intuitive and i started to like building reports in Power Bi. 

Since I want to use the data from the different locations, i installed the on-premise data gateway on these servers and was able to connect to an ODBC datasource as this seemed the way to go. It says the connection is succesful. And thought all would be quite straight forward from there. 

Now my on-premise data gateway is setup, i can't seem to find any information on how to actually get the data from these different data gateways and incorporate them into my reports. It's almost like i'm missing something obvious. 

 

I tried connecting to the data gateway from within Power Bi desktop, but it seems like there's is no option to do so or i'm just not seeing it.

 
My question is:

How am i intended to get the data from my on-premise gateway on an schedule, using an ODBC datasource and combine this date into a report. (just get some tables from these locations and let it update on an schedule)

Sorry for the long read!


 


  • Anonymous's avatar
    Anonymous
    9 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.

12 Replies