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.)

If you liked my solution, please give it a thumbs up. An if I did answer your question, please mark my post as a solution. Thanks!

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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)