Power BI Refresh Error

[PBandI]

I have not changed anything in my Power BI reports and upon trying to refresh I am presented with the following error:

I have tried to assess where the type mismatch may be in the "Opportunity" column but I am unable to resolve the issue. I have looked on the forums and seen suggestions to copy the table, delete the original, and then rename the copy back to the original but that did now work. I have tried removing any "Changed Type" steps in Power Query Editor pertaining to the table in question, as well as looking at the data types for most columns within this table. Any help would be greatly appreciated. 

[vanessafvg]

are you able to share the file at all?

where are you trying to find the issue in power query?   does changing all  your columns to text help?  where are you pulling the data from?

[PBandI]

I'm not sure I can share the file as it pertains to my company's information. I am trying to find the issue in any of the applied steps within power query that pertain to the Opportunity table. The data is being pulled from Microsoft Dynamics 365 (CRM) and the opportunity associated with it has over 100 columns which makes it difficult to locate the issue. In the table we have date fields, text, number, etc. so I'm not sure changing them all to text would help resolve the issue. 

[vanessafvg]

it will tell you if you have a data type issue.  you have a type mismatch error, which sounds like it could be a data type issue, you can also check this way;

what do you see when you look at power query?

have you turned this on these settings

By default, Power Query performs this data profiling over the first 1,000 rows of your data. To have it operate over the entire dataset, select the Column profiling based on top 1000 rows message in the lower-left corner of your editor window to change column profiling to Column profiling based on entire dataset.

This will tell you if you have a data type issue.

https://learn.microsoft.com/en-us/power-query/data-profiling-tools

you can also create a copy of your power bi file, and change all the fields to text and see if that table has an isssue.  but the above might be easier, depending on how much data power query has to profile.