Forum Discussion
Helper IVHow to deal when ..Power BI dashboard Source data- changed and Table name / Column headers renamed ?
Hello Members !!
Am Working on a Power BI dashboard which is connected to Excel file Data Source available there in local system.
Now client has moved that datasource on Azure SQL Database, where there are number of Tables (added few more unrelevant tables). Also names of (Relevant Tables and Relevant Columns) has been changed .. few more columns are added into the relevant tables.
What would be the best possible way to continue with the same dashboard or I would need to re-create the same as there there are 5 dashboards which looks very time consuming excersice.
Experts kindly suggest me what to do here. ?
thanks...
In PowerQuery if you just double click on a column name you can change it. Once you have changed a couple (it will add all the changes in a single step) you can see what the code looks like in the formula bar.
10 Replies
- jdbuchanan71
Super User
Hello DeepDive ,
I would say your best bet is to rebuild using the new data structure and names.
You could make a query against the Azure source that goes through all the steps to remove new columns and change names from the new name to the old name so it matches the old format exactly. Then go into the advanced query editor and copy the code form the new query and paste it over the code for the old query (the excel data source).
The problem with doing it this way is, the first time there is a problem with the data and you go to their data guys and say that the 'Order Amount" is wrong and they look in the Azure DB and there is no such field because the new name is 'Order Line Quantity' you have a whole new set of problems.
DeepDiveHi jdbuchanan71 , thanks for your response. Is it the way if I change my data source to Azrure DB and then make changes/modification in my existing dashboard like go to each components and change the dax accordingly Or I just re-create the same.
Thanks.
- jdbuchanan71
I would add the Azure data sources to your existing model and change the DAX to the new sources. That way you can see what the old numbers looked like as you are making the changes. Once you are done making all the changes you can delete the old sources from your model.