Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys, the dashboard I created is linked to an Excel source and everything was working fine, but now the dashboard won't refresh anymore, because I get an error in the Power Query. Could it be due to a change in the source Excel file or is it an error in the Power Query? Because two weeks ago, everything was working perfectly 😞
Thanks
Solved! Go to Solution.
Dear UjjawalTyagi518, thank you for the suggestion. It turns out there were two columns added to the source Excel file by someone and these were of course not accounted for in the Power Query Editor in Power BI. So I manually typed in these column names in the steps and the dashboard works again!
hi @anoniem,
As you said you have connected through a excel data source, and you are getting this error.
it is happing because the data which you are getting from the excel file have some nulls, and when it connect to power query for refresh, the query will apply the same steps which u already did will formating and editing the excel file.
SOLUTION
You can replace the value from null to 0 in your excel, then this error will be resolved.
let me know if that works for you!
thanks
Dear UjjawalTyagi518, thank you for the suggestion. It turns out there were two columns added to the source Excel file by someone and these were of course not accounted for in the Power Query Editor in Power BI. So I manually typed in these column names in the steps and the dashboard works again!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.