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

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
dkay84_PowerBI
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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.