After updating to October release of Power BI Report Server we were very excited to be able to upload reports used with imported data from SQL Server directly.
When we refresh the report with latest data in desktop then upload to the report server it renders fine and all is well.
I then setup the scheduled refresh, after the scheduled refresh happens all the data becomes blank.
The outline of the report is there but no data is visible.
I then use the desktop edit the report and the data shows, I refresh on the desktop and save it to the report server and the data is visible again.
In the logs is shows the report is being refreshed successfully.
2017-11-28 02:00:01.9115|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Data Refresh.
2017-11-28 02:00:01.9428|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Retrieving PBIX AsDatabaseInfo.
2017-11-28 02:00:01.9740|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Verifying all the data sources are embedded.
2017-11-28 02:00:01.9896|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Verifying connection strings are valid.
2017-11-28 02:00:02.0521|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Streaming model to Analysis Server.
2017-11-28 02:00:05.9583|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Refreshing the model.
2017-11-28 02:00:22.4579|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Removing credentials from the model.
2017-11-28 02:00:22.7704|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Saving model to the catalog.
What am I doing wrong? Would appreciate any help.
