Forum Discussion

felipecca's avatar
felipecca
New Member
2 years ago

The project seems dont update (SQL)

Hi,

 

I´m new here and at the PBI.

 

My projetct updates from sql but I cant filter the new data in my layout, it stil with older data in.

 

The project was populated with data from 2017 to 2019 at first time. Now I populated it with data from 2022 to 2024.

But when I filter data between 2022 and 2024 it dont show any data.

Thanks

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi felipecca ,

     

    Verify that the data in the time range is loaded correctly with code similar to the following:

    SELECT * FROM YourTable WHERE DateColumn BETWEEN '2022-01-01' AND '2024-12-31'

    Also check if it's the effect of the date filter that's causing it.

     

    Refer to below document:
    Types of filters in Power BI reports - Power BI | Microsoft Learn

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • felipecca's avatar
      felipecca
      New Member
      2 years ago

      Hi, Anonymous.

      Thank you first of all of supporting me.

       

      I did the two steps.

      At the frist I get data, but at the second I din´t get data, as shows below.

      My code is a litlte bit differente because It´s portuguese. " SELECT * FROM EVENTS WHERE EVENT_TIME_UTC BETWEEN '01-01-2023 00:00:00' AND '31-12-2024 00:00:00' "

       

       

      May I deduze that I´m not updating it correct?