Forum Discussion

TMO_KY's avatar
TMO_KY
Icon for Helper II rankHelper II
6 years ago
Solved

Power BI missing some data from SF report

Good Morning Community,  I was wondering if anyone has run into issues where Power BI doesn't pull all the data from a Salesforce Report.  Here are some screenshots for what I'm talking about. 

From SF:

Power BI:

I should be seeing "Joe Snuffy's" Time off in Power BI, anyone have any ideas?  It would be greatly appreciated.

Need Help
  • TMO_KY's avatar
    TMO_KY
    6 years ago

    aj1973   So I found the issue, I didn't realize it at the time but I got to messing with it again this morning.  Salesforce native reporting allows a limit of 2,000 rows only unless you export the data.  So the report was picking and choosing which data to show me on the screen but was reporting different data to Power BI.  Still don't understand that one but I changed some edits in my SF report to limit the rows of data and everything is showing perfectly in Power BI.   Thanks again for reaching out to offer assistance.  Cheers!

7 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi TMO_KY 

    Are you using a native query against your data source? in you Query editor I see a filter applied (third line on the right in applied steps) try to delete it and see how it worksout.

     

    Regards

    • TMO_KY's avatar
      TMO_KY
      Icon for Helper II rankHelper II
      6 years ago

      Thanks for the reply aj1973 

      My apologies, I thought I added that information in the original post.  I added the filter to both the SF report and the native query to show the examples otherwise I would have had a ton of data and it wouldn't have been as clear to see the discrepancy between the 2 reports.  So even with zero filters on either side, the data is still missing on the Power BI query.

      • TMO_KY's avatar
        TMO_KY
        Icon for Helper II rankHelper II
        6 years ago

        aj1973   So I found the issue, I didn't realize it at the time but I got to messing with it again this morning.  Salesforce native reporting allows a limit of 2,000 rows only unless you export the data.  So the report was picking and choosing which data to show me on the screen but was reporting different data to Power BI.  Still don't understand that one but I changed some edits in my SF report to limit the rows of data and everything is showing perfectly in Power BI.   Thanks again for reaching out to offer assistance.  Cheers!