Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

error after changing from excel import to entering data directly in Power BI

Dear all,

 

I have imported an excel sheet and saved data from it in two tables in Power BI so far.

Now I created tables with the same data directly in Power BI instead and replaced the imported tables by them, since the tables are very small (1 row, 4 columns) and the excel import causes trouble when installing a data gateway.

However, after replacing the old tables by the new, I get the following error message:

The data type 'XM_TYPE_REAL' does not match the expected data type 'XM_TYPE_INT' for the column 'x' in table 'y' .

 

Can you help me? 

 

Thanks

Susanne

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Dear HotChilli ,

     

    I have checked the data types and they were actually all set as "decimal", so I just recreated the columns dependent on the data in table 'x' and now for some reason it works ^^

     

    Thanks anyway!

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Well it looks like powerbi expected an INT in one of the columns but a decimal turned up instead.

    So it's probably fixable by changing the data type in Power Query or Powerbi front end

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Dear HotChilli ,

       

      I have checked the data types and they were actually all set as "decimal", so I just recreated the columns dependent on the data in table 'x' and now for some reason it works ^^

       

      Thanks anyway!