Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
7 |