Failed To Load Data Scheduled Refresh - Privacy Settings Are The Same

Question

Hey guysI am combining into a table data from Salesforce, a Web API (Which the privacy has to be set to None for it to work) and a sharepoint online list.&nbsp;Refresh works perfectly in the desktop version but when scheduling it on the service it bombs out with the error&nbsp;Last refresh failed: Mon Mar 01 2021 15:12:21 GMT+0000 (Greenwich Mean Time)There was an error when processing the data in the dataset.Hide detailsProcessing error:Information is needed in order to combine dataCluster URI:WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.netActivity ID:c1a98239-275d-4622-bb90-64b46c39dadcRequest ID:796f8cfc-6246-4e82-b77a-07f97fe2ae01Time:2021-03-01 15:12:21Z&nbsp;Done the usual googling and I have changed all the privacy settings both in the desktop app and online - Set them to none, organisational, public &amp; private so they are both the same but still get this error.&nbsp;Really struggling to understand whats happening - Any one suggest anything?

gilbertq · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Do you have the following value enabled on your gateway?
&nbsp;

&nbsp;

anonymous · Answer

Hey&nbsp;GilbertQ&nbsp;&nbsp;Strangly it says it doesnt need a gateway and doesnt give me the option to switch one on&nbsp;

gilbertq · Answer

Hi&nbsp;Anonymous&nbsp;
Under data source credentials when you click on Edit, make sure that the Privacy settings are set to NONE

anonymous · Answer

Yes I tried all the usual stuff you can find on google - Tried setting the privacy to every combination but didnt work.

I have 2 other reports - 1 that is purley from the same Sharepoint instance, and 1 thats from the same Production Salesforce environment all work fine - I think its just because i am combining data from each into one data subset that its having a wobble. Very strange in deed

v-luwang-msft · Answer

Hi,I found your situation in another thread with a similar situation, you can refer to the following thread and try to operate according to the solution.Good luck!Information is needed in order to combine data Table - without Gateway：https://community.powerbi.com/t5/Service/Information-is-needed-in-order-to-combine-data-Table-without/m-p/716816#M70140 Wish it is helpful for you!Best RegardLucien Wang

Forum Discussion

Failed To Load Data Scheduled Refresh - Privacy Settings Are The Same

7 Replies

Related content

Schedule refresh

Schedule refresh

Refresh/ Scheduled Refresh sudddenly disabled

Scheduled Refresh Failure

Cannot schedule refresh or data source settings

Processing error:	Information is needed in order to combine data
Cluster URI:	WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID:	c1a98239-275d-4622-bb90-64b46c39dadc
Request ID:	796f8cfc-6246-4e82-b77a-07f97fe2ae01
Time:	2021-03-01 15:12:21Z