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

[Anonymous]

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

[HotChilli]

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 · Accepted solution]

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!