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 compan...
Need Help
Tutorial Requests
  • 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.

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

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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

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