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.

LeonardoCSilva's avatar
LeonardoCSilva
Frequent Visitor
2 years ago

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's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Check for any columns without type definition.

  • LeonardoCSilva's avatar
    LeonardoCSilva
    Frequent Visitor
    2 years ago

    I already checked, all columns has 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.