Forum Discussion

rbiswas's avatar
rbiswas
Frequent Visitor
9 years ago

Data connection issue in Sales force

Hi,   I am facing an issue in importing a report from the salesforce.com website.   It seems that in the get data dialog box, there is no reports whose name starts with 'N' and beyond (N-Z) thoug...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi rbiswas,

Power BI Desktop uses Salesforce report REST API to pull report data, and Salesforce report Rest API has the limitation, for example, a list of up to 200 recently viewed reports can be returned, please check that if you hit the limitations described in this article.

In addition, please check that if your account permission differs on the returned reports and missing reports.

Thanks,
Lydia Zhang

  • rbiswas's avatar
    rbiswas
    Frequent Visitor
    9 years ago

    Hi

     

    I had gone through the article. But, it was not much of a help. It's really wierd that similar issue is occuring in the power pivot addin in excel.

     

    Is there any other way to connect to salesforce.com. 

     

    Regarding account permission, in the salesforce.com I do have access to relevant reports.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi rbiswas,

      You can also directly connect to Salesforce content pack from Power BI Service.  Or you can use Salesforce Objects connector in Power BI Desktop to connect to your data source.

      Since Power BI retrieve all data that Salesforce connector provides, if your issue still occurs, I would also recommend you post the question in salesforce forum to get dedicated support.

      Thanks,
      Lydia Zhang