Forum Discussion
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 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
3 Replies
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
Click the little Fx at the left of the formula bar
and type
= Record.ToTable(Source)
And what happens if you click on Tools?
