Forum Discussion

aAmirkHan's avatar
aAmirkHan
Helper III
1 year ago
Solved

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

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 video...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    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

Jai-Rathinavel's avatar
Jai-Rathinavel
Super User
1 year ago

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

Related content