Unable to convert "To Table" view in Power Query while using #shared in Power Query

[aAmirkHan]

Hi,

Earlier, I was able to convert "To Table" when many functions were available by using #shared. However, I cannot view or convert that function into a table. Although I have watched so many videos on this but unable to find the solution.

Please suggest.

[PwerQueryKees]

And what happens if you click on Tools?

[PwerQueryKees]

Click the little Fx at the left of the formula bar

and type

= Record.ToTable(Source)

[Jai-Rathinavel · Accepted solution]

@aAmirkHan Try copy pasting the below code by clicking on Advanced Editor for Query1

let
    Source = #shared,
    #"Converted to Table" = Record.ToTable(Source)
in
    #"Converted to Table"

If you still end up with an error, try opening a new file or install the latest version or Power BI Desktop.

Did I answer your question ? Mark this post as a solution

Thanks,

Jai