cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Neptune87 Frequent Visitor
Frequent Visitor

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.Annotation 2019-06-25 174112.jpgAnnotation 2019-06-25 174224.png

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: dataflows is truncating my 19 digit number

Hi @Neptune87 ,

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

Untitled.png

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Neptune87 Frequent Visitor
Frequent Visitor

Re: dataflows is truncating my 19 digit number

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"

Community Support Team
Community Support Team

Re: dataflows is truncating my 19 digit number

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bi-team New Member
New Member

Re: dataflows is truncating my 19 digit number

Explanation of the fundamental need to solve the bigint problem in dataflow:

For us, this problem occurs when trying to load data from accounting system tables (1C) into a power bi project via dataflow.  Initially, the values of the key fields of all tables of the accounting system (1C) have the form similar to this  "ed1f21b7-6978-4cf0-8129-8ed16-f738103-dfeab1" .  Which allows you to make power bi projects using text key fields in downloadable tables.  But on big data, this makes the project heavier and slower.  

Provided, that millions of users work with the accounting system (1C), we would like to work with the BIGINT type for long key fields in DATAFLOW without unnecessary transformations and to have the INT64 data type worked equally well in both the power bi desktop project and dataflow.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)