Forum Discussion

Helper I

9 years ago

Change SQL Server IP address Analysis services from data sources

Hello Currently in our company, we have 4 cubes deployed in our server named BI with an IP address XXX.XXX.XX.XX. We have connected Power BI to these data sources through (SQL Analysis Services) ...

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

Microsoft Employee

9 years ago

Hi JulianTobon,

You should be able to change the source data address by clicking Data source settings under Home tab > Edit Queries.

The reports already designed and pointing to that address won't be affected, and will still work in this scenario. :smileyhappy:

Regards

Helper I

9 years ago

Is in Power BI Web no in Power Bi desktop :manfrustrated:

v-ljerr-msft
Microsoft Employee
9 years ago
Hi JulianTobon,

I don't think there is an option to change the server address of an existing Analysis services within a Gateway on Power BI Service currently.

In your scenario, you can just add a new data source for your Analysis services with the new IP address within your Gateway on Power BI Service. And you still need to change the data source settings to the new IP address on Power BI Desktop, then republish it to Power BI service. So that the reports already designed and pointing to that address won't be affected, and will still work. :smileyhappy:

Regards