Forum Discussion

ramesh_bethini's avatar
ramesh_bethini
New Member
9 years ago

Power BI Reports source connection change

Hello,

 

I am trying to chnage the data source(sql connection) for my power BI reports which are published and in live with a different data source.Please let me know the steps. i am using gateways also.

Thanks in Advance.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    ramesh_bethini You won't be able to do that in the Service. You need to change the connection in the Desktop (hopefully you started there)

    Click on "Edit Queries" > Data Source Settings and you can modify the connection there.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi ramesh_bethini

     

    You also could create a parameter which would be your Server Name.


    You can add this parameter to your SQL Server Source, so that all that you would need to do is to change the Parameter and refresh your data.

     

    NOTE: If you are using an On-Premise Gateway your Data Source Name in your On-Premise Gateway in the Power BI Service MUST match your Server Name in your Data Source Connection in Power BI Desktop.