Issue scheduling refresh with blend data source.

[jingw319]

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 🙂

[v-luwang-msft]

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

[v-luwang-msft · Accepted solution]

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-machin... 

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

Best Regards

Lucien

[Balexandreis]

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.