Forum Discussion

jingw319's avatar
jingw319
Regular Visitor
4 years ago
Solved

Issue scheduling refresh with blend data source.

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.  Ha...
Refresh
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

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