cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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.

 

27 REPLIES 27

Thanks

Administrator
Administrator

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 

Anonymous
Not applicable

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. 

@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?

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. 

 

Cheers

 

desktop.pngservice.png

Same issue on Power BI Server and changing the data type of the page filter from Boolean to Whole Number fixed the refresh issue. 

Frequent Visitor

Hello,

Any new news about this issue? it is frustrating! The dashboard is still showing blanks after a refresh! 

Regards

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors