Forum Discussion
Power BI Refresh Error
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.
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.