Update Power BI Online

[LeonardoCSilva]

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?

[lbendlin]

Did you make changes to the semantic model?  If so, did you update the app?

[LeonardoCSilva]

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.

[LeonardoCSilva · Accepted 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.

[LeonardoCSilva]

I already checked, all columns has type definition =/