Forum Discussion
Error with Refresh
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.
5 Replies
Privacy levels must match across all sources.
Are these true Web connections or are you accessing Excel files on Sharepoint?
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.
Then you should use SharePoint Folder connections, not Web connections.
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
In my originial post I stated that all privacy levels are the same. They are all set to none. Am I not udnerstanding something?
