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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
Anonymous
Not applicable

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.