Forum Discussion

cyan's avatar
cyan
Helper I
8 years ago

IsLatest date filter on a table column

Hello everyone,   I have applied a date filter (IsLatest) on a table column in Power BI Desktop report (through edit queries) then I published to power bi service, now the problem is that, when I o...
Need Help
cyan's avatar
cyan
Helper I
8 years ago

Hi v-jiascu-msft,

 

Do you think that the filter is desinged to work only on the local version but doesn't work when you publish to Power BI service? were you able to produce the problem?

 

Thanks.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi cyan,

 

I think I found the root cause. Did you set up Schedule Refresh in the Power BI Service? Or refresh the dataset manually in the Power BI Service? If you want to show up the latest data in your embedded application, you have to refresh the dataset first.

Is_Latest_date_filter_on_a_table_column

 

 

Best Regards,

Dale

  • cyan's avatar
    cyan
    Helper I
    8 years ago

    Hi v-jiascu-msft,

    I have scheduled refresh, plus my report is connected to the source with Direct Query, also to make sure, I did manual refresh for the dataset like you mentioned, the dataset is updated because I have other pages in the same report where I don't use the IsLatest date filter and those pages are updated but the page with IsLatest Date filter keeps showing old data.

    Is the IsLatest filter working for the test report you created? are you able to see the data filtered by the latest date in Power BI Service? If it's working for you do you think it's not working for me because I am using Direct Query!!? 

     

    Thanks.

  • cyan's avatar
    cyan
    Helper I
    8 years ago

    Hi v-jiascu-msft,

     

    Is the IsLatest filter working in the sample report you created on power BI Service? any updates?

     

    Thanks.