Forum Discussion

markp's avatar
markp
Icon for Helper I rankHelper I
8 years ago

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...
Scheduled data refresh
Evelien's avatar
Evelien
Icon for Advocate I rankAdvocate I
8 years ago

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

markp's avatar
markp
Icon for Helper I rankHelper I
8 years ago

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

  • Evelien's avatar
    Evelien
    Icon for Advocate I rankAdvocate I
    8 years ago

    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

     

    • Evelien's avatar
      Evelien
      Icon for Advocate I rankAdvocate I
      8 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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