Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
Proud to be a Super User! | |
And what happens if you click on Tools?
Click the little Fx at the left of the formula bar
and type
= Record.ToTable(Source)
@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
Proud to be a Super User! | |