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

Source link

Be the first to comment

Leave a Reply

Your email address will not be published.