Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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...
Solved! Go to Solution.
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.
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.
Hi @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.
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.
What are you trying to change on the columns? If you are wanting to change the data source you would need to start a new query from scratch using Get Data > Azure > Azure SQL Database to pull your table into your model.
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.
Thanks @jdbuchanan71 for the solution. I am also looking to change the column names of one table basis the another table. Means there are two fields in second table in which one fields have old coulmn names and other fiels have new column name. And basis this table, how can i rename main table coulmn name.
Thanks
If you look in the query editor you can see the column renaming syntax, you would just add the aditional columns in there. Just build the rename string in excel and paste it into the query editor. I wouldn't try messing with using a table to rename the columns in another table.
Ok thanks for your support.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |