Go to Solution.
You can click on the 'error' and it will let you know what value is causing the issue.
It is likely that the data type is not compatible with how that field is set up or it could be a #div error or #N/A.
You may need to clean up the source data.
Proud to be a Super User!
View solution in original post
On Power Query Editor go to Home tab and remove errors.
See image below
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.