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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
shivanilarokar
New Member

need help with API getting bad request error while fetching data as data source is custom connector

 

hello  community, plz help me to resolve  this my data source is custom connector & fetching data via API. I am getting constant error as bad request  due to hitting no of calls sometime data is pulling sometimes not  even i applied multiple transformation steps on one table that also disappears how to deal with this ??? Please help me my goal is to get up to date data from other system to power bi via api.  

1 REPLY 1
v-yangliu-msft
Community Support
Community Support

Hi  @shivanilarokar ,

 

Ensure that your authentication token or credentials are valid and configured correctly, that you have all the required permissions, and that the values entered for tenantId, reportId, groupId, and datasetId are correct.

 

There may be a problem with the body of the request that is now using a connection string that does not match the Power BI design, this cannot be used directly with the new one and a matching one must be used, you can try the following rest api link and re-send it in the report to get the connection string that matches the template as the template to be modified, to modify the connection string that is being used.

 

Datasets - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Datasets - Get Gateway Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Lea...

 

You can check out the following troubleshoot on Rest API error messages:

Troubleshoot Power BI REST APIs - Power BI | Microsoft Learn

 

You might consider using Fiddler to get more information about the error, perhaps related to RLS:

Solved: 400 Bad Request Error when embedding report - Microsoft Fabric Community

 

This is the related document, you can view this content:

Solved: Power BI REST API ExportTo Bad Request - Microsoft Fabric Community

Solved: Status code 400 (bad request) on some Admin API ca... - Microsoft Fabric Community

Solved: Power BI REST API Bad Request Object must implemen... - Microsoft Fabric Community

Solved: Rest API executeQueries Python - Microsoft Fabric Community

 

Best Regards,

Liu Yang

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.