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

Anonymous — Fri, 06 Sep 2024 17:11:03 GMT

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.

Re: need help with API getting bad request error while fetching data as data source is custom connec

Anonymous — Mon, 09 Sep 2024 02:42:12 GMT

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 Learn

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.

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

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

Re: need help with API getting bad request error while fetching data as data source is custom connec