Scheduled Refresh Completed but Data Does Not Update (Only Happens at Start of Month)

Hi,

I'm encountering an issue with scheduled refresh in Power BI Service every start of the month. The scheduled refresh log shows it refreshed the data as scheduled but when I checked the dataset, report, and dashboards the data was not refreshed.

I had to manually refresh the data in Power BI Desktop and upload it to the Power BI Service in order to get the updated data. This always happen every start of the month onwards wherein the data is not getting refreshed anymore by Power BI Service. 

The Power BI reports that has this issue are those that have different data sources and have a relationship between tables coming from different data sources. I usually use SQL data and have a custom table inserted for lookups in the relationship. I'm also using Direct Query. I'm not sure which of the states contributes to the issue. Hopefully you can help me with this issue.

Best regards,

Mark V.