topic Re: Issue scheduling refresh with blend data source. in Report Server

Issue scheduling refresh with blend data source.

jingw319 — Thu, 12 May 2022 22:40:56 GMT

Hi Everyone,

I have a data source blending excel on SharePoint and Smartsheet for my dashboard. When I tried to schedule a routine refresh, I ran into this error message, see screenshot below. Has anyone run into this before? Any suggestions?

Thank you in advance 🙂

Re: Issue scheduling refresh with blend data source.

Balexandreis — Thu, 12 May 2022 23:32:16 GMT

Estou com o mesmo problema, mas só que é do Excel e SQL

Preciso agendar a atualização destes dados, mas antes preciso corrigir este erro.

Re: Issue scheduling refresh with blend data source.

v-luwang-msft — Wed, 18 May 2022 08:07:13 GMT

Hi jingw319 ,

You need to reset the permsions on the power bi cloud (service) side by clicking edit credentials and setting he privacy settings and entering the password (see screen shot below). Its now refreshing fine.

And check if the account have the same permission of your own account. And go to Manage Gateways, ensure Privacy Level for these all sources is public or none as well. Then refresh the dataset again.

Similar error code case refer:

https://community.powerbi.com/t5/Service/Information-is-needed-in-order-to-combine-data-Table-machine/m-p/923059

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

Re: Issue scheduling refresh with blend data source.

v-luwang-msft — Wed, 25 May 2022 07:17:02 GMT

HI jingw319 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien