Forum Discussion
Error loading table but query editor shows no error rows
Hello ROKRI
first of all I would reccomend to use this formula, instead of yours
= Table.AddColumn(#"Added Receivable Balance", "Current FY Actual ICR %", each if [FY20 Actual Direct]=0 then null else ([2020 Expenditure]-[FY20 Actual Direct])/[FY20 Actual Direct], type number)otherwise you have a mixture of data-type text and number.
In Power Query you can use the try otherwise syntax to get the errors, but I think the NaN is not covered here.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi ROKRI ,
You could click error to see detailed error information. In addition, you also need to check each step to see which step have error and try to modify it to see whether it work or not.
And you said that when they are seperate, they are ok, so did you mean that when they combine, something wrong in steps? Please check it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello dax ,
Thank you for the response.
I did check the detailed error information by clicking the link. I've also gone through each step and fixed errors as they occur. The final step in the applied steps is clean, all data loads fine without errors, but when I go into PBI desktop and refresh, I'm still getting the error notice. Though, the table in query is blank. I am familiar with instances where there are actual errors loading data in PBI desktop and then am able to go into query editor and resolve. However, this time, there's no query errors to resolve. Just the blank table as per image.
Perhaps it has something to do with column order or new columns added or something. Again, all the data is there.
Does that clarify?
Thanks,
Russ