Forum Discussion
Data source update
Hi,
I've transformd my data via Power query by adding new column with a calculation, removing other columns. Now I've added new data to my data source but when I try to refresh my dashboard on Power BI it fails. Help please.
16 Replies
Hi FatiFlaubert ,
Can you share some screessnhots around the issue please? This is not helping much.
Add error screesnhot as well which you are facing.
Thanks,
Pragati
Can you please share the details of the failure ? did you add more columns or new rows in data?
FatiFlaubert , Can you share the error. Open the edit query/transform data mode. You should see some error there
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTsI've deleted this column on power query and also from my data source
Hi FatiFlaubert ,
The error is easy to understand. One of your column is missing. Is this column used somehwhere on your report?
Also, go to power query editor, start from the first step where you have SOURCE under applied steps section and see where it is going wrong.
Thanks,
Pragati
Seems like your column 'X-Coord' gets removed from the source table.
You might need to add the column again or go to Power Query Advanced Editor and remove the column where it is getting used.
Actually this column was removed, I don't need it and didn't use it
Hi FatiFlaubert ,
Based on above screesnhot --> Go to View on the top ribbon --> check Formula Bar
Now you will see the actual formula for ChangedType step.
Under Change Type step you will see that this column has still has a refrence, therefore it is giving error. You will have to remove this column name from this step to fix this error.
Check similarly for other steps as well.
Removing columns directly from datasource doesn't mean they query steps get updated everytime.
Thanks,
Pragati
Hi Pragati11
After deleting the column name from the formula bar and trying to save I got this :
Hi FatiFlaubert ,
Looks like you have deleted a token within the expression like comma, brackets, etc. along with the column name.
Did you take backup of the previous formula bar value? If not close the pbix file without saving and open it again and then be careful when you remove a column reference from this formula.
Or before closing pbix, scroll to the right on the error and see where it is giving error.
Thanks,
Pragati
Hi FatiFlaubert ,
you may need to check if you wrote the function in the rigth syntax since a little mistype could possibly couse error.
Best Regards,
Yuna
Here is the function, could you please check with me ?
=Table.TransformColumnTypes(#"Promoted Headers",{{"Month", type date}, {"Market", type text}, {"Team", type text}, {"MD", type text}, {"Ped Calls", Int64.Type}, {"Nurse Calls", Int64.Type}, {"MW Calls", Int64.Type}, {"Pharma Calls", Int64.Type}, {"Other Calls", Int64.Type}, {"Medical Calls", Int64.Type}, {"Total Calls", Int64.Type}, {"Ped Calls %", type any}, {"Nurse Calls %", type any}, {"MW Calls %", type any}, {"Pharma Calls %", type any}, {"Other Calls %", type any}, {"Med Calls %", type any}, {"F2F Calls %", type number}, {"Remote Calls %", type number}, {"Working Days", type number}, {"Call Rate", type number}, {"Call Sub Time in Days", type number}, {"%A", type number}, {"%B", type number}, {"Avg A freq", type number}, {"Avg B freq", type number}, {"Coaching sessions", Int64.Type}, {"Column40", type any}, , {"A", Int64.Type}, {"B", Int64.Type}, {"% A", type number}, {"% B", type number}, {"rest A", type number}, {"rest B", type number}, {"Double", Int64.Type}})
Hi FatiFlaubert ,
Did you deliberately add an extra comma in the place circled in the screenshot below?
Best Regards,
Yuna
Thank you . Indeed it was an error. Now after correcting it and deleting also other errors, what this could mean ?
