Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Service Report stops returning data

Hi We have a Sevice report. This is working fine,  then stops returning any data. The report refreshes without error but returns no data.   The fix is to download the report to desktop, refresh th...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Finally I think this has been solved. This is a direct query report, so the filter below requires a download and refresh 

     

    #"Filtered Rows" = Table.SelectRows(#"Sorted Rows", each Date.IsInCurrentMonth([Date])) 

     

    The solution is to change the logic so the query is passed through to the database

     

    #"Filtered Rows" = Table.SelectRows(#"Sorted Rows", each ([ThisMonthFlag] = "Y"))

     

    This makes sense now. but I am not sure if this behaviour is by design ?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Just happened again. Data is only returned from the dbo tables. Download the dataset and refresh then upload to service. All is working again. Client is not happy. Anyone any ideas? Can anyone at Microsoft pick this up ?

TheNov3mberist's avatar
TheNov3mberist
Advocate I
8 years ago

Been having the same issue. It broke earlier this week when the issues began. Now that it's "resolved", I had to delete the data source from service and republish from the desktop. It appears to be working okay now but we'll see how it goes.