Forum Discussion
Service Report stops returning data
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 ?
This continues to be a problem. Each month we make a change to some flags in the date dimension, current month, current week. It is a though the date dimension is not refreshed because when the flags change data is no longer returned. (there is a currentmonth=Y in the report filter.
The fix is to download the report refresh and upload. The client is doing this manually every month. I have tried tweeking the sql account. As said in posts above there are a number of schemas in the database. we have not given access to some schemas. I am goin to take that away and give db read to all schemas as I have a hunch that the bug is there.
Next will be be db owner and then full admin ;) I wonder if the fix could be to not use sql authentication .... can we use an AAD account ?
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 ?