Forum Discussion
After a scheduled refresh the report has no data
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.
33 Replies
Hello,
Any new news about this issue? it is frustrating! The dashboard is still showing blanks after a refresh!
RegardsI recently started having the same problem. After reading all the responses on this thread, I went through my reports to rid them of any boolean data types to eliminate that as a possible factor.
Still experiencing the problem. The reports displayed as they should after scheduled refreshes until one day they didn't.
beaujeffrey03 Was your issue resolved?
I am having a similar situation - A report with a grid and few slicers renders fine for a few days and then it goes blank. Dataset is scheduled to refresh daily. I am not sure what is the cause.
Cause: Is the presence of boolean data types in the PBI dataset the reason for this issue ? The columns that I am using on the visuals are actually text columns with values "Yes" or "No". So I am not sure.
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.
Hi All,
I am facing the same issue. After going through these comments changed boolen page level filters to text it worked for a day or so then again am facing the same issue. Please let me know if any other way to reslove this issue
Thanks
Well I'm glad it's not just me.
I too am experiencing similar issues. I have a number of the same report hosted on the Report Server, each just filtering to a different location (until we can successfully use RLS) for security reasons. Each report is scheduled for a 30 minute refresh of data.
Some of these reports periodically fail to show any of the visualisations, yet everything works fine if I refresh the desktop version.
This results in me having to re-upload to the report server jsut to get everything running again.
Very strange indeed. Are there any successful solutions yet?
I had a similar boolean issue. I think it is because I used an untyped field as a page filter. Must have been that desktop interpreted it as text or boolean, while service interpreted it as int. When I changed it to the correct type in m query, it worked fine in both desktop and service. I suppose this same issue could arise with data types other than boolean.
- 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..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?
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
Hello I have the similar issue, just published and one of the visual is not visible by another admin user. Please advise.
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 YuVersion is <Product>Microsoft Power BI Report Server Version 14.0.600.437</Product>
Have tried multiple browsers and doesnt help.
This is still occuring after the March update.
@v-qiuyu-msft @mgmeyer @riccardomuti Assistance with this is appreciated.
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
I havent found a solution unfortunately. I would hope someone from Microsoft would help here.
I can confirm that I had the same error and was able to resolve by changing my Boolean from "True" or "False" to "1" or "0" and after I made that change and republished the reports now display as intended online.
