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

  • trchourasia's avatar
    trchourasia
    Frequent Visitor
    8 years ago

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

     

    Tanvi

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

      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

      • renanc's avatar
        renanc
        Icon for Helper II rankHelper II
        7 years ago

        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?