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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

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  @Anonymous ,

 

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.