Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Powerbi dataset refresh error: OLEDB OR ODBC Error: Datasource.Error Sharepoint Request failed

Dear Team
 
I am facing issue while refreshing the PowerBI Desktop file:
OLEDB OR ODBC Error: Datasource.Error Sharepoint Request failed
 
Please find below screenshots:

 

 
Regards
Arun
 
Need Help

5 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Hello Anonymous ,

     

    Can you go to Power Query Editor and see if all there is any error on any of the 'Applied Steps' while data transformation.

    Also check if the data sources that you are attempting to connect to from Power BI are able to make the connection successfully

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Dear PC2790

       

      I am not getting any error in Transform Data Power query editor while refreshing each query manually

      When I click on Close and Apply and then apply query changes then i am getting this error each time in different query. I am able to successfully establish connection to the files in the Sharepoint folder 

      Could someone from Microsoft support team help us in resolving this issue at the earliest as it is impacting the development

       

      Regards

      Arun

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI Anonymous,

        Did this issue appear immediately when you getting data or show after you do some operations in the query editor and save changes? If that is the case, any operations you applied between these steps? Please share more detailed information to help us clarify your scenario:

        How to Get Your Question Answered Quickly

        For example:

        data source structure changes, change the sign-in user account, advanced operations in the query editor.

        Regards,

        Xiaoxin Sheng