Forum Discussion

Neptune87's avatar
Neptune87
Frequent Visitor
7 years ago

dataflows is truncating my 19 digit number

I am getting data from on-prem SQL Server through dataflows and the last 2 digits of the 19 digit number are being changed to zero. Below is a screenshot of the data in SQL and Power Query after it is moved through data flows.

 

Need Help

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Neptune87 ,

    By my test in power bi service with the dataflow, I cannot reproduce your issue.

    Actually, this is similar to that when we get data from SQL Server in power bi desktop.

    Do you have this issue when you load data from SQL Server in Power BI Desktop?

    In addition, what data type of the CallID do you set in your Database?

    Best  Regards,

    Cherry

     

    • Neptune87's avatar
      Neptune87
      Frequent Visitor
      7 years ago

      Hi v-piga-msft,

      Thanks for looking into this.

      When I load the same table from Power BI Desktop all 19 numbers come over with no issues.

      In SQL the Data Type is set to "bigint"

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Neptune87 ,

        By my tests with bigint type, I could reproduce your issue.

        I'm afraid that should be by design in dataflow.

        For a workaround, you may change the data type to be nvarchar so that it will be detect as text type when load in dataflow, then you could change it to be whole number type.

        Best Regards,

        Cherry