Issue with schedule Data Refresh

[Kissooniswar]

Hello,

I was hoping someone will be able to help me with a schedule Data Refresh activity. So i have couple of Excel files which are saved in my network drive. I used Power Bi desktop and publishing the report using PowerBi online. I have to daily open the pbix file and refresh it with new data from my excel file. However, i wanted to schedule an auto refresh but it is failing daily with different message. (i have replaced my report name by XX below and also the network path renamed.

An error occurred while processing the data in the dataset.

Refresh failed:

XX has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"File\",\"path\":\"B:\\\\6 TEAM\\\\POWER BI DEVELOPMENT\\\\excel file "},{\"kind\":\"File\",\"path\":\"B:\\\\6 TEAM\\\\POWER BI DEVELOPMENT\\\\excelfile.csv\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: SALES DATA FOR DETAILED REPORTING.

Technical Information

Activity Id:

b4977897-f12d-4d67-8c1f-d6fa733b047d

Request Id:

dc1556df-a379-43c8-92c7-f74817e3f1b4

Cluster Name:

WABI-EUROPE-NORTH-B-redirect.analysis.windows.net

[GilbertQ]

Hi there

The issue is that for the Privacy settings for your Excel files have different combinations.

You will need to update the privacy settings in your PBIX and the data source on the Gateway to match.

I typically set them all to NONE and it then works.

https://blog.crossjoin.co.uk/2017/07/04/data-privacy-settings-in-power-bipower-query-part-4-disablin...