Forum Discussion

Sandeep's avatar
Sandeep
Helper I
10 years ago

Change connection to database

HI Team,   We have created few dashboards using existing Excel file. Now as a part of long term strategy we have uploaded the excel data into SQL Azure and automated the process of data refresh.  ...
Sandeep's avatar
Sandeep
Helper I
10 years ago

Thanks MAllington,

 

 

Here is my thoughts:

 

1. Open .pbix file and open in new Power BI Desktop window.

2. Go to Edit query --> go to advance properties --> change connection string 

 

3. Update Database name and Report dataset --> Save and close.

4. Then it should bring back all the dashboard.

 

but it seems, it is breaking the dashboard which is created using excel file which means it's not working.

 

Thanks,

Sandeep

 

ImkeF's avatar
ImkeF
Community Champion
10 years ago

Sandeep 

The way you've described it should work. But there are a lot of steps between changing the connection and your final report so next step should be to identify where things go wrong.

 

1) Check if the query whose connection you've changed returns the expected result. If not: step through the steps to see where the error occurs.

2) If the query runs through it's still possible that the connections to other tables got broken due to format problems (i.e. if you haven't explicitely set the format in the key columns)

 

If you haven't done already, I'd start to check the lines directly following the connection string.