Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have the following situations:
Dataflows created on SQL views. Original SQL columns exceed the INT SQL data type limitations and therefore are created as numeric(10,0).
If I select the column values as they are in View, the numbers returned don't have any decimals. Hovewer Power BI Dataflow reads the original data type from SQL (numeric) and then determines data type = decimal. These columns are keys used in Power BI relationships!
I'm trying to figure out if I should change data type to get whole number in Power BI or just leave it as decimal. Is there any implication in performance if decimal data type is used, although all the numbers are actually whole numbers?
Solved! Go to Solution.
Hi @asuteu10 ,
If your data is integer, then I think it is best to use Whole number type in Power Query.
For more information about the impact of different data types on performance, please refer to:
https://www.sqlbi.com/articles/choosing-numeric-data-types-in-dax/
https://www.excelguru.ca/blog/2019/08/27/do-data-types-matter-in-power-query/
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @asuteu10 ,
If your data is integer, then I think it is best to use Whole number type in Power Query.
For more information about the impact of different data types on performance, please refer to:
https://www.sqlbi.com/articles/choosing-numeric-data-types-in-dax/
https://www.excelguru.ca/blog/2019/08/27/do-data-types-matter-in-power-query/
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.