Forum Discussion

LeonardoCSilva's avatar
LeonardoCSilva
Frequent Visitor
2 years ago
Solved

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 ...
Need Help
  • LeonardoCSilva's avatar
    LeonardoCSilva
    2 years ago

    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.

lbendlin's avatar
lbendlin
Super User
2 years ago

Check for any columns without type definition.

LeonardoCSilva's avatar
LeonardoCSilva
Frequent Visitor
2 years ago

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.