Forum Discussion
Datatype is not same while importing from SQL Server with direct query in power BI desktop
Hello Everyone, Datatype for sql server 2012 with direct query import to powerbi is not the same. SQL Server 2012: Powerbi: Ex. in SQL Server 2012 datatype was int but...
Hi Krishna1992,
It seems like you change column type after get data to power bi. If you create new report with same data source, did this data type issue appears again?
If data type issue fixed on new report, I'd like to suggest you save your direct query mode report as template.
After these steps, you can try to use template file to generate new report with same datasource to see if data type issue fixed.
Deep Dive into Query Parameters and Power BI Templates
Regards,
Xiaoxin Sheng
Hi Anonymous,
I have converted in sql server and imported into the power bi.
No Issues thanks for the comment.