cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

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

Highlighted

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

 

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

 

 

 

 

Highlighted

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

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors