Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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