cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cwilliams Regular Visitor
Regular Visitor

2.60.5169.4101 64-bit (July, 2018) Version

Is anyone having issues with the newest version? 

Not all data is being imported into the Query Editor.

 

Cheryl

1 ACCEPTED SOLUTION

Accepted Solutions
cwilliams Regular Visitor
Regular Visitor

Re: 2.60.5169.4101 64-bit (July, 2018) Version

Resolved this issue by duplicating the column mentioned above and then using the original column for splitting the column.

 

Cheryl

6 REPLIES 6
RMDNA Senior Member
Senior Member

Re: 2.60.5169.4101 64-bit (July, 2018) Version

Hi @cwilliams,

 

Could you expand on your actual issue? What do you mean when you say not all data is imported?

cwilliams Regular Visitor
Regular Visitor

Re: 2.60.5169.4101 64-bit (July, 2018) Version

One query has column named Bam_id which refers to the FY and account number. There are 20 characters for this field. The first character refers to the fiscal year and the last 19 characters is the account #. When I split the column by 1 character from the left, only records from FY 2012-2013 are visible, even though all the other years were visible prior to the split. I have been troubleshooting the last 2 days – no luck. This just started after the 1st new version in July, 2018. Today, I am updated the BI application with the 2nd version: 2.60.5169.4101 64-bit (July, 2018) Version. After today’s update, I am still having the same issue. Does this make sense?

cwilliams Regular Visitor
Regular Visitor

Re: 2.60.5169.4101 64-bit (July, 2018) Version

I have noticed also, that there is a quick error message that pops up while splitting this one column.

The error message states:

 

"Unexpected Error:  The preview for Section1/Bamast/Split Column by position doesn't exist."

 

Cheryl

Community Support Team
Community Support Team

Re: 2.60.5169.4101 64-bit (July, 2018) Version

Hi cwilliams,

 

"There are 20 characters for this field. The first character refers to the fiscal year and the last 19 characters is the account #. When I split the column by 1 character from the left, only records from FY 2012-2013 are visible"

 

<---- Can't reproduce your issue. Could you share your pbix file with some sample data as an example for further test?

 

Regards,

Jimmy Tao

cwilliams Regular Visitor
Regular Visitor

Re: 2.60.5169.4101 64-bit (July, 2018) Version

The column I was having difficulty with may be a primary key of the table.  Before making a copy of this column, I split the column and then made a copy of the single digit and then merged the single digit with the other 19 characters.  This seems to have resolved the issue.

 

Prior, I made a copy of the above column and then split the copy not the original.  I was having the issue with the copied, split column.

 

Cheryl

cwilliams Regular Visitor
Regular Visitor

Re: 2.60.5169.4101 64-bit (July, 2018) Version

Resolved this issue by duplicating the column mentioned above and then using the original column for splitting the column.

 

Cheryl