Forum Discussion
Workflow using the On-Premise data gateway and ODBC
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.
Super UserSee Lydia's reply in http://community.powerbi.com/t5/Desktop/Publishing-dashboard-to-Office-365/m-p/79843#M33277
Maybe this will help more and seems she has more experience in this area
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-msftMicrosoft Employee
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
v-ljerr-msft Hi, thanks for helping me out!
I already added a datasource to my gateway.
So for example:
i have database A on location 1.
On my location 1 server i make a System DSN ODBC connection. i call it DATABASE_A.
I install the On-Premise data gateway on this server.
In app.powerbi i add the gateway and name it DATABASE_AThe datasource i also name DATABASE_A
I then get data from this location 1 server local on my workstation, open it in power bi desktop. Save it as DATABASE_A.pbix and publish it.
It will then connect to my data gateway and refresh on schedule because the pbix i published is named exactly the same as my data gateway?- v-ljerr-msft
Hi Anonymous,
The gateway name, pbix file name and the data source name don't need to be the same. When the pbix file is published to the service, it will detect the data source it needs from all the data sources within the gateways.
Regards