Forum Discussion

_megynmc's avatar
_megynmc
Frequent Visitor
6 months ago
Solved

Power BI / Salesforce Report Connector - Does it even work???

Hello, We have been trying to connect to a Salesforce Report through Power BI (Power Query) using the Salesforce Reports Connector. We have already submitted a case through Salesforce Support and th...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    6 months ago

    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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
6 months ago

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.

  • v-tejrama's avatar
    v-tejrama
    Community Support
    6 months ago

    Hi _megynmc ,

     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

    Thank you.

    • _megynmc's avatar
      _megynmc
      Frequent Visitor
      6 months ago

      I have a scheduled call with Microsoft support today.

      • v-tejrama's avatar
        v-tejrama
        Community Support
        6 months ago

        Hi _megynmc ,

         

        If you have any further questions or need additional assistance, please feel free to reach out here anytime.

        Thank you.

  • _megynmc's avatar
    _megynmc
    Frequent Visitor
    5 months ago

    The Salesforce Admin updated something on their end, which finally allowed the reports to be exposed. I am guessing that it was in, in fact, related to the REST API because now I can see all of the reports including the one I was looking for.