Forum Discussion
Update Power BI Online
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?
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.
5 Replies
- lbendlin
Super User
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.- lbendlin
Check for any columns without type definition.
