Power Query privacy level and firewall error

cedinger

New Member
Joined
Oct 12, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hello all,

I have created some queries in excel using power queries with no issues until recently. In the last month or so the reports that I have previously been using with no issues at all are all now requesting privacy level data settings be setup or just giving me the dreaded firewall error. I know I can select to ignore privacy levels, however I want to actually understand what the actual problem. In my research I have tried redesigning my queries multiple different ways based things that I have found on the web. However today I a very basic query to test and I was not expecting to receive an error..

So I created a Named range in a new blank workbook, with a folder path referenced. Then imported that Named range into power query within the same workbook and drilled down on it, in order to use it as a parameter in other works books. I came across one video today discussing how to do do this and avoid the firewall error. The video mentioned pulling the folder content directly into this first query to create a staging query, using the Folder.Files() function in PowerQuery. As soon as I added the code to do this, I received a request to provide data privacy levels for the source. I don't understand why I get this request every time I connect to a source now, when I was never receiving this popup previously.

Power Query:
let
    Source = Excel.CurrentWorkbook(){[Name="ExcelTableFolderPath"]}[Content],
    Path = Source{0}[Path],
    Custom1 = Folder.Files(Path)
in
    Custom1

I was under the impression if I did the folder.files m code in the same initial query that I would not get the privacy level error, so I just set the privacy level to public to test it. Sure enough I got the error. So I have 2 questions.

1) Is there a reason that Power Query is all of a sudden requesting me to provide the data privacy levels for every source when it has never done this before? Maybe I accidently screwed up some type of privacy permissions that were already in place, which is now requiring me to provide always provide it?

2) Why would privacy Level concerns be creased from the example above?

Thank you,
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
What are your privacy levels set at now? What were they before this started to occur?
 

Attachments

  • Capture9.JPG
    Capture9.JPG
    41.5 KB · Views: 42
Upvote 0
I don't know what the settings were previously before i started receiving the pop-ups on all my files... Now that I'm thinking about it, the first time I started seeing the issue is after emailing the file to a coworker so they could save their own version. The team member replied back almost immediately that they had firewall error.

I must have deleted something in error when trying to figure out why he was having the issues.

Im leaning towards me clearing my global permissions..
 
Upvote 0

Forum statistics

Threads
1,223,912
Messages
6,175,341
Members
452,638
Latest member
Oluwabukunmi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top