cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnJairoV Regular Visitor
Regular Visitor

Re: Transform Data with Power Query

Hi @ImkeF! Awesome! Thx for your Example and explanations from you.

 

I have a last question about it.  You use Json.Document instead of Excel.CurrentWorkbook, result of making the query from table into Excel.  What is the advantage of use Json?

Super User
Super User

Re: Transform Data with Power Query

Sorry, should have said this: The Source-expression using JSON should be replaced by the reference to your table.

(I just used it to "ship" sample data with so that you can just copy/paste the code into the advanced editor and see the results.)

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

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




JohnJairoV Regular Visitor
Regular Visitor

Re: Transform Data with Power Query

Great @ImkeF! all clear now.  Thx for your support.  Blessings!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,337)