Forum Discussion

michellefs_br's avatar
michellefs_br
Icon for Helper I rankHelper I
10 years ago

Refresh on Power BI.com different from Power BI Desktop

I'll try posting here, in hope that the community can help as I've opened a tkt with microsoft and they are useless, no answer from them, and I have a customer on production relying on that. So, we ...
Need Help
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

michellefs_br You can start by troubleshooting yourself to figure out where problem is. 

 

1. In power bi service first use published dataset and create a new report with kpi visual which gives you the count of number of records. Do similar in power bi desktop and see if number matches. Do this first by publishing a new report to service and then do same after doing first refresh.

 

2. Power BI service has several content pack for Dynamics CRM online and i would suggest use that to see that if data returned back is complete or partial. In power bi service go to Get Data -> Serivces -> search 'dynamics' and use appropriate.

 

I would suggest you follow above two step and come back with findings and we can then workout next steps to pinpoint issue. 

michellefs_br's avatar
michellefs_br
Icon for Helper I rankHelper I
10 years ago

Numbers don't match, 4753 Signups in Power BI Desktop against 4163 in power BI online. It is showing less data than it should.

  • Vicky_Song's avatar
    Vicky_Song
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    michellefs_br, Dynamics CRM is refreshed automatically once a day, how about you manually refresh the dataset to see whether you get the complete data? 

    • michellefs_br's avatar
      michellefs_br
      Icon for Helper I rankHelper I
      10 years ago

      Same issue, even when refreshed manually, the refresh does complete succesfully but the data is still wrong, different than Power BI Desktop and CRM itself.