Forum Discussion

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...

Need Help

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
Date Slicer Filter.pbix56 KB

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.