Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys
I have three Dashboards that uses datas from SQL Server.
All Dashboards I programmed to update online 3 times p/day. But, only one every time gives the error below:
The following system error occurred: Type mismatch. Table: "Vencidas" |
I do evreything, but load, load, load and nothing happened.
Can someone help me?
Solved! Go to Solution.
I contacted Power BI Suport and they help me solve the issue.
I had an column type date that PBI Online couldn't read and didn't work.
I changed the type date by type text and work well now.
I can't explain exctly te error, but that was the answer of team microsoft:
"from the source data type 'VT_BSTR' to the expected data type 'VT_DATE'. Please check the column data types in the data model and data source and ensure that the data types are compatible"
Anyway, thank for help me.
Did you make changes to the semantic model? If so, did you update the app?
No. I didn't change the semantic model. I deleted the Dashboard and published it again but didn't work 😥.
When I update the dataset on Power BI Dasktop, it's work normally.
Check for any columns without type definition.
I contacted Power BI Suport and they help me solve the issue.
I had an column type date that PBI Online couldn't read and didn't work.
I changed the type date by type text and work well now.
I can't explain exctly te error, but that was the answer of team microsoft:
"from the source data type 'VT_BSTR' to the expected data type 'VT_DATE'. Please check the column data types in the data model and data source and ensure that the data types are compatible"
Anyway, thank for help me.
I already checked, all columns has type definition =/