Forum Discussion

luisreyes's avatar
luisreyes
Frequent Visitor
3 years ago
Solved

Data in SQL is different when imported at Power BI

Hi,

 

I have a DB in SQL server, and i'm looking for connect it to Power BI for automatic reporting.

 

This is the Query i'm importing

i apply a date filter in Power BI, and take the first row (VPR13 that show 914) to confirm the data,  (The filter date is 2022-07-01/2022-09-30)

In SQL, i apply a filter with the same date, the query gets 899 results 

 

But when i change the filter to 1 day more (2022-07-01/2022-10-01) , it shows 914, exactly the same that power BI show when the date is 2022-07-01/2022-09-30.

 

What can be happening?

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi luisreyes ,

    In Power BI, if you select the date range which is from 01/07/2022 to 30/09/2022, the data between 01/07/2022 00:00:00 and 30/09/2022 23:59:59.999 will display in the visual not the data between 01/07/2022 00:00:00 and 30/09/2022 00:00:00 . That's why it will return 914 rows of data instead of 899 rows of data.

    I create a sample pbix file, you can find the details in the attachment.

    Best Regards

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi luisreyes ,

    In Power BI, if you select the date range which is from 01/07/2022 to 30/09/2022, the data between 01/07/2022 00:00:00 and 30/09/2022 23:59:59.999 will display in the visual not the data between 01/07/2022 00:00:00 and 30/09/2022 00:00:00 . That's why it will return 914 rows of data instead of 899 rows of data.

    I create a sample pbix file, you can find the details in the attachment.

    Best Regards