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.  Has anyone run into this before? Any suggestions?

 

Thank you in advance 🙂

 

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

3 Replies

  • Balexandreis's avatar
    Balexandreis
    New Member
    4 years ago

    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.

  • 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

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

    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