Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Sapna_Chopra
Regular Visitor

Reduced text in column when merging datasets

‎02-05-2020 03:03 AM

Hi Guys,I have a data set which has questions and answers from a survey but when I merge this dataset with another dataset based on ID, I get incomplete text for each question.Could you advise the reason behind this.

Thanks 

Sapna

Labels:
Message 1 of 3
350 Views
0
2 REPLIES 2
vanessafvg
Super User
Super User

‎02-05-2020 03:36 AM

@Sapna_Chopra  can you please explain a bit more how you are doing this?    How much text is in each answer?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Message 2 of 3
339 Views
0
Sapna_Chopra
Regular Visitor
In response to vanessafvg

‎02-05-2020 03:42 AM

Hi Vanessa,

Before merging the datasets the length of  each question(which is each a column of yes/no) was  even more than 200 charecters (the questions are long) but when I merged this questionnaire dataset with another dataset based on ID,the length of questions are now restricted to 80. The dataset merges fine but I dont know the reason behind this decrease in  length

Thanks

 

Message 3 of 3
335 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All
Top Solution Authors
View All