Excel: Power Query report with Pivot table sharing via email

Question

I have monthly data in excel files and folder which I have organized to an excel sheet via power query.

In the same power query file, I converted that query table into the Pivot table for further analysis.

Now, when I sharing that same file to the email for my colleagues, the data is also going with it and I believe they can able to update the query and get the latest data as well.

How I can avoid sending the data along with the power query file and how to restrict my recipients to update the data?

Answer 1

Publish the file as a PDF

Answer 2

Hi,

In my opinion, you can load the Query data as a Table, and delete the Query from list:

Then create a new PivotTable based on the table.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.