No data upload in one column from Excel to Power BI

[jcabrera]

Hello everyone, 

I have a problem with the updating data of a column from Excel to Power BI Desktop. 

So every column is OK in Power BI, except this one, I dont know why it doesn't appear the correct data as in the other column... in the excel it has the same format as the rest as well as in Power BI.

Any suggestions?

[timalbers · Accepted solution]

The problem is the function Number.IntegerDivide in line 13. When you have values like 30 or 40 and perform an integer divide with 100. The result is always 0. Try to use the same function like for the column Reflejos - two lines above.

[jcabrera]

Ok, everything works now.

Many thanks.

[timalbers]

Hi @jcabrera ,

based on your descripiton and screenshots its pretty hard to tell where the problem is. Are you able to upload a screenshot from the query in the query editor? Just click on "Advanced editor" in the relevant table in the Power BI  Query Editor. Be aware to hide sensitive information like exact data source paths etc...

Greetings

Tim

[jcabrera]

Yeah sure, no problem: