I'm loading several tables from snowflake, where all the number fields are integers, but they appear in powerBI as decimals, looking really bad on the dashboard, do I have another solution apart from changing one by one all the fields in powerquery? maybe something like change a configuration to load the numbers properly
Any help is appreciated, thanks!
I'm having the same problem. It seems to be caused by the fact that Snowflake treats all integer values as number(38,0). So, when this is imported into PBI, it is seen as a decimal type. This is causing two problems for me...
@rajulshah of course, I attach a link to the csv file I downloaded from snowflake with the "fact_residencias" and another link for the powerbi file, also I put some photos of how is that table store in snowflake.
powerBI file: https://jmp.sh/J9ixLSC
csv file with fact_residencias data: https://jmp.sh/pOSXVR2
photos of fact_residencias in snowflake:
Unfortunately, I cannot load the data as I don't have the credentials but when I import from the sheet that you provided, I am getting properly formatted data.
Yeah, when I import the data from the csv I'm also getting properly formatted data, the problem is when I'm importing the data from snowflake, what credentials is asking you?
Hello @JoseD ,
Please change the Regional Settings to English(US) or English(India).
Go to File>Options and Settings>Current File>Regional Settings.
Please let me know if this doesn't work.
Hello @rajulshah , thanks for you help, I tried changing Regional Settings to English(US) and English(India) but neither of them worked, I still have the issue.