Forum Discussion

FFilardo's avatar
FFilardo
Regular Visitor
4 years ago
Solved

Difference between PowerBI Desktop and online reports

Hi all, I have a problem with a sales report that work perfectly in PowerBI Desktop but does'nt work in online version.   In detail, the data connector use Dynamics 365 where sales for customers d...
  • FFilardo's avatar
    4 years ago

    After many hours I found the problem and solved 1 day ago.

     

    The problem was the sales calendar Date passed into the service, 1 day  less the information passed into the Desktop.

     

    Then, the 01/01/22 sales informations into the desktop, was converted to 31/12/21 sales informations on the cloud.

     

    The solution was to simply create a new sales caledar Date column with +1 day