Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

PBI Connect to Excel Workbook on OneDrive - API Request Service Error with status 500

Hello,

 

I am in the GCC tenant and have multiple users reporting they cannot use excel workbook through OneDrive as a source for data.

Clicking on new report, choosing excel, clicking on Browse OneDrive, results in an unexpected Error: ApiRequest UnknownServiceError with status 500

 

It appears this API connector to OneDrive is non functional in my tenant. I have no ability to create a ticket to microsoft on PBI issues.

 

Any help or guidance appreciated.

Status: Investigating

Hi  @JasonK1 ,

 

Please ensure that the service you're trying to connect to is up and running. Sometimes, the service might be down for maintenance or experiencing issues.

Double-check the API endpoint you're using in Power BI. Ensure that the URL is correct and that there are no typos.and make sure that your API request includes the correct authentication tokens or credentials. An incorrect or expired token can lead to a 500 error.

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @JasonK1 ,

 

Please ensure that the service you're trying to connect to is up and running. Sometimes, the service might be down for maintenance or experiencing issues.

Double-check the API endpoint you're using in Power BI. Ensure that the URL is correct and that there are no typos.and make sure that your API request includes the correct authentication tokens or credentials. An incorrect or expired token can lead to a 500 error.

 

Best Regards,
Community Support Team _ Caitlyn