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?
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."
"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?
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.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!