Hello. There is a problem when a Snowflake table has columns with datatype number(p > 15,0) column is detected as a decimal number of with a maximum precision of 15 in Power BI desktop. Basically all our primary keys / foreign keys are defined with number(p > 15,0). This then makes Power BI direct query a no-go for us. This is not a limitation of Power BI. More so Snowflake datatype always appearing like decimal in their declaration as numeric(p,s) prevents Power BI desktop to use the whole number datatype for Snowflake columns with number(p,0) data types
Hi @aj1973_ ,
The step is not supported in DirectQuery mode. How did you convert the datatype with import mode?
Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The link of Power BI Support: Support | Microsoft Power BI
For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community
Community Support Team _ Caitlyn