Error with Refresh

[christopherocc]

Hello.

Im trying to setup scheduled refreshes but I am receving this error for both schedule and maunal refreshes. On desktop the file refreshes perfectly fine. 

Data source error:Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: SpineSport AR.
Cluster URI:WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID:099c8f3c-4ced-465f-93c9-b5afccccfde5
Request ID:358f4cb2-57da-bb0b-5d5b-32ed143c7b03
Time:2024-12-16 08:37:06ZDetails

I look at similar posts and I made sure of the following:
I made sure all of these credentials on Services are configured.

On Desktop I made sure all of these are the same.

I also have this option enabled.

I appreciate any help. I wish things like this weren't so convoluted. 

[suparnababu8]

Hi @christopherocc 

yes I agree with @lbendlin   answer, you have to match privacy level across all sources. Hope below yotube videos will help you to solve the problem

https://www.youtube.com/watch?v=kqYtrwXmpVc

https://www.youtube.com/watch?v=poI_XJNWTtc

[christopherocc]

In my originial post I stated that all privacy levels are the same. They are all set to none. Am I not udnerstanding something?

[lbendlin]

Privacy levels must match across all sources. 

Are these true Web connections or are you accessing Excel files on Sharepoint?

[christopherocc]

In my original post I stated that all privacy levels are the same. They are all set to none. Am I not udnerstanding something?

I am accessing Excel files on Sharepoint.

[lbendlin]

Then you should use SharePoint Folder connections, not Web connections.