Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
aAmirkHan
Helper II
Helper II

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 videos on this but unable to find the solution.

Please suggest.

 

aAmirkHan_0-1734751048964.pngaAmirkHan_1-1734751112056.png

 

 

1 ACCEPTED SOLUTION
Jai-Rathinavel
Super User
Super User

@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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
PwerQueryKees
Super User
Super User

And what happens if you click on Tools?

PwerQueryKees_0-1734794556385.png

 

PwerQueryKees
Super User
Super User

Click the little Fx at the left of the formula bar

and type

= Record.ToTable(Source)

 

Jai-Rathinavel
Super User
Super User

@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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors