Hi ALL,
Firslty @Expiscornovus thank you for your solution!
And @Inspiremais ,It seems that you're encountering a "Type mismatch" error with the "deals" table in Power BI when viewing the report in the Power BI service。
Here are a few things to try to resolve this issue:
1.Check Data Types:
Ensure that the data types in the "deals" table are consistent across the desktop and service versions. Sometimes, data type mismatches can happen if the schema is slightly different.
You can check the data types in Power BI Desktop by going to the Modeling tab and verifying the column types for the "deals" table.
2.Refresh the Data in Power BI Service:
Go to the Power BI service and refresh the dataset to make sure that any recent changes to your data or model are properly reflected in the service.
You can do this in the workspace where the report is published by clicking on the More options (three dots) next to the dataset and selecting Refresh now.
3.Check the Data Source Settings:
Sometimes, issues in the Power BI service can occur if the data source is not properly configured or if there are issues with permissions. Verify that the data source credentials are correct in the service by going to the Settings of the dataset and checking the Data source credentials section.
4.Check for Version Differences:
There may be a version mismatch between the Power BI Desktop file and the Power BI Service version. Ensure that the latest version of the report is published to the Power BI Service. You can publish the report again from Power BI Desktop to ensure the service has the most up-to-date model.
5.Review the Query Dependencies:
Sometimes, transformations or query dependencies in Power Query can cause issues. Open the Transform Data window in Power BI Desktop and review any applied steps in the query for the "deals" table. Ensure that no data transformations are causing conflicts.
6.Check for Hidden Columns or Tables:
If you have any hidden columns or tables in the model, ensure that their data types are correct and consistent across the service and desktop versions.
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
