No Error Msg

[zqlcancer]

In the past when I refresh PB data, system will pop up a window to inform you if you have an error. Now this message is gone even if I see error in my data. Does anyone have any idea what happened? Do I need to turn on anything in option?

[Anonymous]

Hi  @zqlcancer ,

In power query, you can choose Home-Remove Rows, click remove errors and check if error disappeared.

In addtion, it seems this issue should be related to data format can't be recognized by power query, I would suggest you to refer to this:

https://community.powerbi.com/t5/Desktop/error-message-after-building-query-returns-zero-rows-in-the...

This is a link to related content, I hope it will help you:

https://social.technet.microsoft.com/Forums/ie/en-US/16b8a8bd-0f48-4db5-8d98-8fbf6089e38b/x-of-the-l...

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=5524f246-...

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=9634c50a-...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@zqlcancer , Power query, and check there should be an error folder with the errors. you can check errors there.

Try like

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

[zqlcancer]

There are no error folder or error msg like before after I refreshed data. But if I look the data in details, I can see the error.