Forum Discussion
Data source error: The following system error occurred: Type mismatch. Table: Encuesta_de_Mercado
Best regard,
I hope they are fine.
Please give your valuable help with this error that I present on the Power Bi Service platform.
Data source error: The following system error occurred: Type mismatch. Table: Market_Survey.
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: bf3ef27d-3585-437e-a88b-fe741f7ec9f0
Request ID: e626db79-6854-ba42-3a00-41e72a53e6a5
Time: 2024-05-23 18:19:46Z
I have done the following:
* The data table in question (Market_Survey) when I updated the data and the report did not present any errors, everything was successful.
* I have already validated the data in each column and I do not have empty or hidden data that could generate the error.
* The data type according to the variable is correctly assigned.
* I delete the report from the Power BI Service, update locally, Publish the report, configure the Gateway and when updating it in the powerBi Service I present the same error again.
I appreciate any help you can give me.
1 Reply
Hi Admin_CSM ,
You've done some checking above, you can also try to simplify the columns in the Market_Survey table to check the issue.
If the problem persists after trying these steps, it can be helpful to gather more information:
1.What is the exact data source (e.g. SQL Server, Excel, etc.) used for the ‘Market_Survey’ table?
2.Are there any calculated columns or metrics in your Market_Survey table, and if so, can you share the DAX formulas used?
3.Are there any Row Level Security (RLS) rules in place that may affect data refresh?Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
