Skip to main content
cancel
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
Ali_2022
New Member

Some Row values are Half-Split into rows below

Ali_2022_0-1647380480751.png

Ali_2022_0-1647380760578.png

 

two values in the second row in the cells next to null (markered with black) should be next to the values in the corresponding upper cells 

 

Please advise how i can fix that on Power Query  

3 REPLIES 3
Vijay_A_Verma
Super User
Super User

Need to look at some sample data to work out the steps for you. Please upload the file without confidential/sensitive data to a cloud storage service such as Onedrive/Google Drive/Dropbox/Box (Onedrive preferred) and share the link here.

artemus
Microsoft Employee
Microsoft Employee

This would depend on how the data is imported, and possibly what the raw format is. You could try to save it as an Excel file and import that?

that is from a web service called Ditat, I can only download pdf format document, then connecting to that PDF through Power BI

Ali_2022_0-1647548955304.png

the highlighted part must be on the same row, but it is split into down below of actual row

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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