Forum Discussion

Krishna1992's avatar
Krishna1992
Helper I
7 years ago

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...
Need Help
Krishna1992's avatar
Krishna1992
Helper I
7 years ago

Hi Anonymous,

 

Used sql server 2012 and latest powerbi desktop.

 

In sql server 2012, added the tables and performed query to change the datatype. Meanwhile when I tried to import it into the powerbi desktop changed datatype (query which I performed doesnt take effect).

 

In import mode also same datatype is appearing but in import mode we can change the datatype.

 

But my issue is I need this in direct query only.

 

Please let me know if anything possible, do I need to change something in sql server.

Thanks.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • Krishna1992's avatar
    Krishna1992
    Helper I
    7 years ago

    Hi Anonymous,

     

    I have converted in sql server and imported into the power bi.

     

    No Issues thanks for the comment.