cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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) and the Gateway is working. Are 4 Data sources with the same IP address and a group of reports have been developed in Power BI.

By infrastructure theme we must migrate this server, so the IP address will change. We are concerned about the subject of data origins, so I ask them:

Can the source data address be edited in Power BI?
What happens to reports already designed and pointing to that address?

 

Thanks

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Change SQL Server IP address Analysis services from data sources

Hi @JulianTobon,

 

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

 

as.PNG

 

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

 

Regards

Highlighted
Helper I
Helper I

Re: Change SQL Server IP address Analysis services from data sources

Is in Power BI Web no in Power Bi desktop Man Frustrated

 

Captura.PNG

 

Highlighted
Microsoft
Microsoft

Re: Change SQL Server IP address Analysis services from data sources

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. Smiley Happy

 

Regards

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors