loading PBi into power query

[dicken]

Hi,
I had a PBi file to which I had added a couple of columns (in pbi) , but wanted to play around with the formula so thought i'd make a copy using power query,
I selected 'transform data' but the file opened up as it originally was no added columns, I'd asso created a table which didn't show up either,
how do I get the updated versions into power query?

Richard.

 

[Matt Allington]

If you add calculated columns using DAX in PBI, they are not available in any way or form in PQ. Under most circumstance, it is better to add the new columns in PQ.

 

[dicken]

If you add calculated columns using DAX in PBI, they are not available in any way or form in PQ. Under most circumstance, it is better to add the new columns in PQ.

Thanks, as long as I know things aren't possible I can stop trying to achieve them.

RD