PowerBI report with direct query needs weekly upload to keep working

[Roel]

I have a report deployed on the powerbi service which has a Direct Query connection to a view of a table on an Azure SQL server.

For some strange reason, every Monday the report stops working. In order to get it working again I need to reupload the workbook.

This is obviously very annoying.

Are there any idea as to why this happens and how I can permanently fix this problem?

[v-diye-msft]

Hi @Roel 

You can probably refer to the notes in the official document:

https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with-direct-connect

If your issue still exist, please kindly raise it to the support team for better advice.thanks!

https://powerbi.microsoft.com/en-us/support/

[v-diye-msft]

Hi @Roel 

Could you please share the error when it's not working? that would be easier for us to investigate it deeply.

[Roel]

@v-diye-msft 

Unfortunately, I get no error.

It just stops working, the dashboard just stays empty. Pulling down in the app to refresh or pressing the refresh panels does nothing.