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.
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.
I 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.
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
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.
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?
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
@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.
I've been having this weird issue for a while !
The data is SQL Server on premis, the gateway is configured properly, all other reports refresh as expected.
Only this report, the first screenshot is from Power BI Desktop and the second one is Power BI Online, the data is from SSISDB, when i publish it to power bi online i get empty report (before even refreshing it!) , even when i try to refresh it i remains the same.
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.
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?
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.
@Evelien Dude I've tried to update the gateway, change data format, and a bunch of other things.
Nothing solved my issue, because for the most people this is a gateway issue.
When I first tried to do your method I've failed, but I did it in a similar way, which worked for me:
I have filtered through the "M" MashUp the related values for "True/False" to just show the "True"/Active values, the ones that I needed.
Than it Worked, so thank you very much for exposing how you solved it!
Just wondering, how did you possible know it was a boolean expression issue, like there was some sort of error displaying for you or you searched for it?
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!