Forum Discussion

ROKRI's avatar
ROKRI
Helper I
6 years ago
Solved

Error loading table but query editor shows no error rows

Hello,   When I refresh my table in PBI desktop the data loads but I get a message there are 10 errors (image 1). However, when I view in query editor, the table is empty with no error rows, only t...
Need Help
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    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

Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello ROKRI 

 

are you using a Table.SelectRows in your query?

 

Jimmy

ROKRI's avatar
ROKRI
Helper I
6 years ago

Hi Jimmy801,

 

Thanks for the response.

 

I am not using Table.SelectRows in this instance as I'm working off the master table and need all data included.

 

I wasn't familiar with this (still learning) and I think this is just what I need to work always out of one table as opposed to the multiple ones. Great idea, though, not my current issue.

 

With reference to dax comment about merging the tables, I meant I have three separate excel files I manually combine into a master one. To be specific, three regional files, Asia, Africa, Middle East I combine to a Global file, manually in excel. The three regional files load fine into PBI desktop, no errors in either deskop or query editor. But the issue is still as initially described, empty error table in editor.

 

For further insight, the same thing happened today when updating the Middle East file with new columns and data. New columns added include FY 2020 data, multiple columns. I'm having the same problem, "1 of the loaded queries contained errors", but the query editor error table is blank. As per dax prior comment, I did resolve a bunch of initial errors preventing data load such as text being in number columns and similar issues prevening data load. With all that resolved, I can now load data but still get error message as per below, however, data is there with empty error table in query editor (second image). Same as issue with global one as per initial post.

 

 

 

I appreciate the continued support.


Russ