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.
Microsoft EmployeeHi 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_A
The 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
The answers i get seem to imply i'm asking some really basic and straightforward stuff, but actually i'm at a total loss again... :/
Do you mean i need to publish the PBIX from the database servers themselves? So i have to install power bi desktop on all these different servers?!
If there is some sort of tutorial available or some basic documentation how to handle this situation i 'd be helped alot.- v-ljerr-msft
Hi Anonymous,
Do you mean i need to publish the PBIX from the database servers themselves? So i have to install power bi desktop on all these different servers?!No, you don't need to pubish the pbix file from the database servers.
If there is some sort of tutorial available or some basic documentation how to handle this situation i 'd be helped alot.I think you need to understand how the gateway works first, and do a few test to understand it better. I also suggest you to start your learning journey through Power BI with a sequenced collection of courses, and understand the extensive and powerful capabilities of Power BI. If you have any questions, feel free to ask.:smileyhappy:
Reference:
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-0-0-what-is-power-bi/
http://exceleratorbi.com.au/top-10-tips-getting-started-power-bi/
https://guyinacube.com/videos/
Regards
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.