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

Vijay_A_Verma

How to see full cell content in Power Query Editor

Use case - Somebody asked me if the cell is not showing complete content then how he can see the complete content of a cell and copy the cell content from there.  You know something is there as at the end as ... (3 dots) will be there when you see the cell content.

I believe this problem many may be facing, hence it is worthwhile to share the tip here.

Basically, I had advised the person how to see SQL statement when Query folding is happening. And he wanted to copy the SQL statement but display was not showing complete SQL statement.

Full Cell Content1.png

Solution - To see the full cell content, just right click on the cell - Drill down - Now you can see complete cell content and can copy as well from there. Simple and easy.

Full Cell Content2.png