My Table suddenly display error sign ?

[admin11]

Hi All

My customer table suddenly display like error sign , may i know how to remove it ? the system still running fine.

Red triangle

[PaulDBrown]

@admin11 

It looks like the data for the field failed to load. Check the query for the table in Power Query and see what the error is.

[admin11]

@PaulDBrown 

This happen when i relfresh the data.

when i take those old file one month ago and reload , the error from Customer Table will happen. 

Paul

[admin11]

@PaulDBrown 

This table is just link table , table not available at PQ.

Paul

[PaulDBrown]

@admin11 

Try changing the DAX to:

Customer = DISTINCT(UNION(DISTINCT(AR[Customer/Vendor Code]), DISTINCT(Sales[Cust_ID)))

[admin11]

@PaulDBrown 

I think found the issue , when refresh , suddenly i notice i got many error. last time dont have this issue , and yet now all report still okay not affected.

[v-kelly-msft]

Hi  @admin11 ,

You are lacking a right-side square brackets in the dax expression:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[admin11]

@v-kelly-msft 

Thank you for looking into my post.

i just check the expression is okay , no missing for right bracket  :-

Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), all(SALES[CUST_ID])) )

I just open my latest version of PBI which below mark error icon :-

Customer/Vendor Code

While i try to delete all table row , and only left with top 8 row. I also notice that thr error sign dis-appear. 

This conclude that when my PBI file load in all the data to PBI file , it cause the error appear. 

See my post on when loading the data i get a lot of error. in below link.

https://community.powerbi.com/t5/Desktop/How-to-remove-error-when-loading-raw-data-to-PBI/td-p/16533...

Below link is my PBI sample file :-

https://www.dropbox.com/s/avpixj0ikeb9bvt/PBT_V2021_303%20Customer%20field%20error.pbix?dl=0

Paul

[v-kelly-msft]

Hi  @admin11 ,

Sorry for the late reply,I found that your .pbix file had been deleted,is your issue solved now?If so,could you pls mark the reply as answered to let more people find the solution?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[admin11]

@v-kelly-msft 

https://www.dropbox.com/s/3mglp9jcz2fg46h/PBT_V2021_333%20error%20on%20customer%20field.pbix?dl=0

Above is my PBI file. 

Pls note that when i delete all the table data , the error will disappear. when i load all the data , the error will appear.

one thing i seek you hep to advise , it the linking approach correct ? 

As i suppect that my bridge table for link company and customer_id may be wrong.

Hope you can advise the right approach.

Paul

[v-kelly-msft]

Hi  @admin11 ,

I didnt see any error in your .pbix file,would you pls check again？

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[admin11]

@v-kelly-msft 

Yes the error dis-appear. Brcause i remove all the data. when i load all the data into PBI file , i get error again.

[v-kelly-msft]

Hi @admin11 ，

I cant load the data without credential,after checking the query editor,seems there are some error existing in table AR and Sales,would you pls check about it?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[admin11]

@PaulDBrown 

Still getting error