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

[Anonymous]

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

[PC2790]

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]

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]

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

[Anonymous]

Hi 

I am getting this data refresh error after I click on Close and Apply in Powerquery editor

Please find below screenshots:

Regards

Arun

[Anonymous]

HI @Anonymous,

OK, I know these changes appeared when you apply changes. What type of operations that you apply to the backend query editor? Can you please explain more about these?

BTW, please do mask on your sensitive data before share.

Regards,

Xiaoxin Sheng