Forum Discussion

Yoga's avatar
Yoga
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Data source change in service

Hi there, I have developed a report and data model in Power BI desktop in Development machine using Direct Query option and trying to deploy in Test server for QA testing the PBIX file but connect...
Need Help
  • Yoga's avatar
    Yoga
    8 years ago

    Thanks XIaoxin for reply.

     

    We maintain one TNS Name in all Dev, Test, Stage and Production servers. Since I use the same TNS in PBIX file, We are able to move the files to all servers without any change as expected. So no need to change in power bi services running in different servers.

     

    Thanks,

    Yoga

SSKLK's avatar
SSKLK
Regular Visitor
8 years ago

Hi,

 

I'm working on Power BI very recently. I generated a report using power BI desktop.

Get Data -> Sql Server (DB in my local machine)

 

I published the report in Power BI server and used on premises gateaway to refresh with up-to-date data. I worked as expected.

 

on premises gateaway -> used Sql Server as DataSource

 

Now, i want to connect DB in another server to this report. DB structure is same. instead of local i want to connect production DB.

 

How to do it? have to install on premises gateaway in production server? or What are the things i need to do for this change?