topic Re: After a scheduled refresh the report has no data in Report Server

After a scheduled refresh the report has no data

markp — Tue, 28 Nov 2017 01:30:19 GMT

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.

Re: After a scheduled refresh the report has no data

v-qiuyu-msft — Wed, 29 Nov 2017 08:10:43 GMT

Hi @markp,

What's your Power BI report server version? Which visual is blank after schedule refresh?

Based on my test in Power BI report server version 14.0.600.437, the report contains a table visual display data fine after schedule refresh completely. In your scenario, please try another browsers to see if the visual still blank.

Best Regards,
Qiuyun Yu

Re: After a scheduled refresh the report has no data

markp — Thu, 30 Nov 2017 02:04:14 GMT

Version is <Product>Microsoft Power BI Report Server Version 14.0.600.437</Product>

Have tried multiple browsers and doesnt help.

Re: After a scheduled refresh the report has no data

v-qiuyu-msft — Thu, 30 Nov 2017 08:58:00 GMT

@mgmeyer @riccardomuti Do you have any idea about this issue? Thanks.

Best Regards,
Qiuyun Yu

Re: After a scheduled refresh the report has no data

markp — Mon, 11 Dec 2017 04:04:09 GMT

@v-qiuyu-msft Any update on this?

Re: After a scheduled refresh the report has no data

markp — Wed, 13 Dec 2017 22:33:37 GMT

This issue is still present even after updating to version:

<Product>Report Server Version 2017.0140.0600.438 ((BI_Server_Current).171208-0126)</Product>

Re: After a scheduled refresh the report has no data

markp — Sun, 21 Jan 2018 20:53:31 GMT

@v-qiuyu-msft Would really appreciate help with this.

Re: After a scheduled refresh the report has no data

markp — Mon, 26 Mar 2018 23:19:51 GMT

This is still occuring after the March update.

@v-qiuyu-msft @mgmeyer @riccardomuti Assistance with this is appreciated.

Re: After a scheduled refresh the report has no data

Evelien — Fri, 06 Apr 2018 11:30:30 GMT

Hi,

I have the same issue.

For me it started today. Reports, which were working fine on the server with a scheduled refresh, show blank graphs as of today. If I delete the report on the server and re-publish it, it shows the report correctly, but as soon as I refresh (manually or with an automatic schedule) it goes blank again. When I refresh the data on the PowerBi Desktop file, it works fine.

Other reports, which are automatically scheduled, work fine on the server.

Is someone investigating this?

Could you please let us know the solution for this?

Thanks.

Kind regards,

Evelien

Re: After a scheduled refresh the report has no data

markp — Sun, 08 Apr 2018 20:11:52 GMT

I havent found a solution unfortunately. I would hope someone from Microsoft would help here.

Re: After a scheduled refresh the report has no data

Evelien — Mon, 16 Apr 2018 10:25:50 GMT

Thanks for your reply, @markp

@v-qiuyu-msft

@microsoft

Could you please help? It is a very crucial step to be able to refresh the data on the server, whether manually or automatically.

Thanks.

Evelien

Re: After a scheduled refresh the report has no data

Evelien — Mon, 16 Apr 2018 15:14:05 GMT

@markp

@v-qiuyu-msft

I have found the solution - at least for my reports - and I hope it will also help you.

In the page filter of the report I was using a Boolean expression (XXX = TRUE). By changing the Boolean values in the table (and therefore also in the filter) to a numeric value (XXX = 1), the report after a refresh on the service does no longer return a blank report.

So, even though the filter on a Boolean expression works perfectly ok in PowerBI Desktop, it does not on the service after refreshing with a data gateway.

Hopefully this will be of any help for your reports as well.

Kind regards,

Evelien

Re: After a scheduled refresh the report has no data

fedia_boughatta — Tue, 17 Jul 2018 15:10:29 GMT

the same case for me here,

I fixed it with automatic refresh I delete the old reports on the server and I re-published them and when I need to refresh them I use only PowerBi Desktop.

I hope powerBI team fix it.

Re: After a scheduled refresh the report has no data

trchourasia — Fri, 20 Jul 2018 09:38:53 GMT

I am facing the same issue. Did you find any solution ?

Tanvi

Re: After a scheduled refresh the report has no data

Evelien — Fri, 20 Jul 2018 11:06:20 GMT

Hi,

I do no longer have the issue. For me it was solved by not using any dimensions with a Boolean value (TRUE/FALSE) in my page filter. It might be worth checking if you have this as well. You can then replace the Boolean value by numeric value (1/0). Hope it helps.

Kind regards,

Evelien

Re: After a scheduled refresh the report has no data

trchourasia — Tue, 24 Jul 2018 06:55:29 GMT

Hi, Thanks for the reply.

My report does not have any Boolean value in the page. And, the issue still persists.

Re: After a scheduled refresh the report has no data

jazzhanya — Thu, 26 Jul 2018 23:13:00 GMT

Hi everyone,

I’m having the same trouble with my dashboard. It started to happen 1-2nweeks ago. I can see all the data shown in the reports with Power BI Desktop. But I cannot see any data shown in the same reports with Power BI server. If I re-publish the pbix. file to the server (i tried both my workplace /app workplace) then I can see the data in the reports again. But if I refresh the server page, all the data disappeares..

Re: After a scheduled refresh the report has no data

Anonymous — Fri, 10 Aug 2018 00:01:54 GMT

I have also been experiencing this issue. For one of my dashboards, the data disappears after a scheduled refresh by the Power BI service even though the refresh has no errors and is displayed as successful in the UI. I checked my report and did find that some of my data was in the boolean format so I switched those and reuploaded to Power BI Service. Several of the scheduled refreshes since that succeeded and I still have all the data. For now, it seems that switching the boolean format or simply reuploading it has at least resolved the issue for now for my display.

Is this bug logged anywhere with Microsoft?

Re: After a scheduled refresh the report has no data

svishwanathan — Sat, 11 Aug 2018 20:58:54 GMT

@Anonymous

I see that you recently encountered issues with one drive refresh. My one drive power pivot dataset was modified on thursday.

I still dont see changes in the service. I have done numerous manual refresh and the scheduled refresh is also succesful

This dataset has been regularly updated and we have never had any issues with seeing changes in the service

Please let me know if you found a resolution and how

Re: After a scheduled refresh the report has no data

Anonymous — Mon, 13 Aug 2018 20:54:15 GMT

@svishwanathan, the issues I was experiencing with OneDrive refresh earlier were unrelated to this. Regarding my OneDrive refresh issue, I did find that I had to re-enter the credentials for the dataset (using OAuth2) in the scheduled refresh section in the Power BI service. After I didn't have issues with the OneDrive source refresh.