Power BI refresh issue

[dshahzad]

Hi,

I am facing issue in refreshing the data. Both normal and schedule refresh are not working and giving error. Error is shifting from one file to another file. However, error keeps on coming on the file in which data is appended. Below is the error that i am facing:

I have changed the privacy settings multiple time however, still getting same error again and again but on different files location. Kindly help me out in resolving the issue.

[dshahzad · Accepted solution]

Hi guys,

Thank you for your support. Issue resolved. There was a mismatch privacy setting of file and folder which was causing the issue.

thank you once again.

[BhavinVyas3003]

• Set Privacy Level to "Always ignore privacy level settings" in Power BI Desktop.
• Replace mapped drives (e.g., F:\) with UNC paths (e.g., \\192.168.x.x\folder\file.xlsx).
• Ensure On-Premises Data Gateway has access to all file paths.
• In Power BI Service, configure Gateway connection correctly for each data source.
• Use Folder connector if appending multiple files from the same location.

[dshahzad]

Hi,

I have double checked privacy levels and they are same for all files. Also, i have set the privacy level to ignore .

Kindly confirm one thing, instead of linking the file in gateway, i have linked the folder in which it will be used. will it effect the refreshing cycle?

[Akash_Varuna]

Hi @dshahzad I think it is due to privacy level conflicts when combining data. Set the privacy levels for each data source in Data Source Settings to Public or compatible levels. Alternatively, disable privacy checks via Options > Privacy > Ignore Privacy Levels. Ensure the gateway has access to all file paths if you're using one.

[dshahzad]

Hi,

I have double checked privacy levels and they are same for all files. Also, i have set the privacy level to ignore .

Kindly confirm one thing, instead of linking the file in gateway, i have linked the folder in which it will be used. will it effect the refreshing cycle?

[Akash_Varuna]

@dshahzad Linking the entire folder in the gateway can cause refresh problems if files inside change or if permissions aren’t consistent. For more reliable refresh cycles, it’s better to link each file individually, ensuring the gateway has proper access to all required files.