Forum Discussion

MT_1909

Copper Contributor

Oct 30, 2023

Data transformation using Power Query?

Hi Everyone, I have a worksheet with 50k+ rows and would like to create a lineage using power query but I can't seem to get it right. Can someone please help? Thank you so much in advance! ...

BI & Data Analysis

excel

Formulas and Functions

power bi

MT_1909

Copper Contributor

Oct 31, 2023

Hi peiyezhu,

I don't think I can use sql in power query or am I wrong?

Also no need for the blank rows.

Please let me know if you know of a solution using the Power Query UI?

Thank you!