Forum Discussion
Problem when changing server from test to production environment
Hi,
I've got a report that is connected a tabular model running on my test analysis services server (ASTEST). I want to change the datasource so that the report is connected to the same model on my production server (ASPROD). When I change the server, all of my visualizations break with the message "Can't display the visual. See details"
Here are the steps I took to change the data source:
- Edit Queries
- Data source settings
- Change server name and specify model name
- Select the correct perspective from my model
I know my model on ASPROD is good and be accessed by PBIDesktop since I created a new report and pointed it to that model with no issues.
Any ideas on how to resolve this? I really don't want to have to recreate this report just because the datasource name has changed.
Thanks!
1 Reply
- v-cherch-msftMicrosoft Employee
Hi AUaero
I would suggest you use the latest version of Power BI Desktop to create the report. Please try to clear cache(Options->Data Load) in Power BI Desktop, clear permission about your data source in Data source Settings, then re-connect to your source and check if the issue still persists.
If it is not your case, you may submit a support ticket.
https://powerbi.microsoft.com/en-us/support/
Regards,
Cherie