Skip to main content
Microsoft Idea

Power BI

Needs Votes

Convert result of Power Query (M) code to persisted data like 'Enter data'

Vote (1) Share
Ruslan Zolotukhin's profile image

Ruslan Zolotukhin on 02 Oct 2018 22:49:39

Convert result of Power Query (M) code to persisted data like 'Enter data'.

For instance, you've loaded a data from Web and then implemented 100 steps on top of it. But you want this result to be persisted. And then be able to just copy M code to another PBIX to have data.

There is an option to disable load of the query but once you copy M code to another file then you need to refresh it again.