cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

How to load m file from a text file

I am currently using Power BI Desktop without the publishing service.  Basically just sharing pbix files.  I would like to pull the M code out my pbix file so it is one less thing the end user can change.

 

I basically cut and paste the current file's M code and put in a txt file on my desktop alongside (eventually will be in a protected file share) with pbix file.  

 

I then put that text file on my c:\.

 

I get an error when attempting to apply & close the query editor with the pbix file.  The error as best I can tell is generic and not defined anywhere.

 

What am I missing?

 

Thanks in advance.

 

Cheers, Scott

1 ACCEPTED SOLUTION

Accepted Solutions

Use the following code:

 

let
    Source = Text.FromBinary(File.Contents("C:\Mcode.txt")),
    Expression = Expression.Evaluate(Source, #shared)
in
Expression

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

What is the error message?

 

You should be able to copy the M code (right click your highlighted queries in the query editor and select Copy) and paste to a text file.  Not sure why that would be causing an error when you try to close the query editor.  

Sorry should have included this part as well.  Is this correct?

 

let
Source = Text.FromBinary(File.Contents("C:\Mcode.txt"))
in

 

 

 

 

Use the following code:

 

let
    Source = Text.FromBinary(File.Contents("C:\Mcode.txt")),
    Expression = Expression.Evaluate(Source, #shared)
in
Expression

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors