Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Information about a data source is required - Sharepoint list

Hi everyone, 

 

I get an error while updating my dataset in online service : 

 

Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: {Name}

 

In desktop, I can refresh everything without any issue. 

 

My dataset is composed of multiple sharepoint lists and excels hosted in another sharepoint. 

I saw multiple posts mentionning security settings and permission, everything is reset and set as "none" (tried "public" just before). 

 

Do you know any way to solve this issue ? 

 

Thanks for your guidance and help 🙂

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    It caused by data source settings. the error can happen if the Data Source credential Privacy Settings don’t match in the desktop app and the Dataset settings on the Service.

     

    Please try to change the all privacy level for all data source to Organizational by editting credential in dataset settings. For more details, please refer to https://ppmworks.com/data-source-privacy-level-change-may-resolve-power-bi-scheduled-refresh-error/

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 


    Can you make sure that you have got the latest version of the Gateway installed?


    There was an update to it yesterday, which could indicate a potential issue?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

       

      thank you for your answer, unfortunately I am not using a gateway for such report, the personal one is not allowed by my organization and the enterprise one is not accessible to me. 

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        It caused by data source settings. the error can happen if the Data Source credential Privacy Settings don’t match in the desktop app and the Dataset settings on the Service.

         

        Please try to change the all privacy level for all data source to Organizational by editting credential in dataset settings. For more details, please refer to https://ppmworks.com/data-source-privacy-level-change-may-resolve-power-bi-scheduled-refresh-error/

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        Best Regards,

        Dedmon Dai