Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dates difference between Power Query and the Report View

Hi, I have this information:   And when I show this in the Report, it shows this:     Also, when I upload the DS to the PBI Service, the information looks good, and when I refresh th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I didn't succeed but I created another column with Date.AddDays in PQ and added 1 day.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

So the period is stating from 8 to 14, but in the report start from 7 to 13.

 

I tried to check timezone but nothing change.

Fowmy's avatar
Fowmy
Super User
4 years ago

Anonymous 

By default, Power Query shows 1000 rows from your data for profiling, If you want to see the total actual count of records, then on the lower left bar, click on Column Profing and choose, "Column Profiling Based On Entire Data Set"

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Fowmy , which is the connection between my issue and that?

    Because the problem is not that I'm finding less information, the problem is that the Power BI is showing different dates for the same period number (all the dates are 1 day back)

    Thanks,

    Marcelo