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

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. 

  • Shawnliddy's avatar
    Shawnliddy
    New Member
    2 years ago

    Thank you for this, Evelien !

    I added a conditional column for true=1 and false =0, then adjusted my DAX to those conditional columns and boom!