Forum Discussion
Power BI / Salesforce Report Connector - Does it even work???
Thankyou, lbendlin, for your response.
Hi _megynmc,Based on our understanding, the 404 error on /services/data/v48.0/sobjects/Report/describe indicates that Power BI is authenticating successfully, but Salesforce is not exposing the Report object metadata endpoint via the REST API. This issue is typically related to API accessibility or permissions.
Please request your Salesforce Administrator to verify that REST API access to the Report object is enabled, that the user has API Enabled, Run Reports, Export Reports, and appropriate folder access permissions. It is advisable to test the endpoint via Salesforce Workbench or REST Explorer. You may also perform a test with a simple tabular report located in an accessible folder to isolate configuration issues.Your scenario is supported subject to Salesforce limitations, such as the 2,000 row cap. If API access is confirmed and the issue persists, we kindly request you to raise a support ticket using the link provided:Microsoft Fabric Support and Status | Microsoft Fabric
We hope that the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
The Salesforce Reports connector works "fine" (if you ignore the infuriating 2000 row limit imposed by Salesforce). Most likely your SFDC AA team has set the API limit higher than 48. Try using 64 or higher.
That Copilot response is despicable, to say it nicely.
Hello! Thank you for your response. Yeah I was kind of grabbing at straws; the Salesforce Support reps weren't of much help either and suggested a ticket with Microsoft lol.
Did you mean 'hasn't set' rather than 'has set'? Just checking since it makes a difference - I will follow up with the Salesforce Admin.