cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BBIUser Member
Member

Multi-row card visual data not refreshing in the Power BI Service with Schedule Refresh?

Hi,

 

I see this issue only in Power BI Service and data gets refreshed (Manual) in Power BI Desktop without any issues.

 

I am using a Multi-row card with 3 calculated Measures in it. The dataset for this table looks like the sample below:

CustomC.png

 

The column "No.ofInstitutes" is a Custom Column which has 

= [4 Y Avg. Chng] > 5 and [Actu. 4 Y Avg] > 10

Only if it is, these columns are > 5 and > 10 it should be TRUE.

 

I have created Measure just to pick the value 'TRUE' from this Custom Column. Here is that one of the Measure where the values are fetched from two different columns.

TotalRowCount = COUNTROWS(FILTER('Table1', 'Table1'[Notable] = "No" && 'Table1'[No.ofInstitutes]="TRUE")) + 0

Is there anything wrong with this DAX?

Should I use a calculated Measure instead of Custom Column? If so, what should that be?

 

I believe, the Custom Column or the DAX Measure is not working properly to get the latest data in the Multi-row card visual in Power BI Service.

I should also say that, there are number of DAX Measures and visuals in this report and known has this issue (means all the latest data can been seen). 

 

Appreciate your help!

 

3 REPLIES 3
Highlighted
Community Support Team
Community Support Team

Re: Multi-row card visual data not refreshing in the Power BI Service with Schedule Refresh?

Hi @BBIUser,

 

What is your data source? If it is on-premise, did you add data source to Data Gateway? Besides, please test on service whether the result returned by measure is changed if using a common card visual to display data.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BBIUser Member
Member

Re: Multi-row card visual data not refreshing in the Power BI Service with Schedule Refresh?

@v-yulgu-msft. Yes, the data source is added to the Gateway and it is On-Premise SQL Data Source. There are around 15 multi-row cards in that report along with other visuals but only one value (Measure) is showing 0 in the multi-row card. 

 

Yes, I am testing with the common card visual.

Also, I deleted the existing dataset and the visual to recreate the same multi-row card visual again to see if this fixes the problem.

 

I wanted confirm if the method I used to create a custom column and then the DAX Measure is right or wrong since I am picking values from two different columns as FILTERS in DAX Measure?

 

I have another similar calculation and multi-row visual using the Custom column and DAX Measure but only difference is the FILTER (in DAX Measure) used is only one column.

BBIUser Member
Member

Re: Multi-row card visual data not refreshing in the Power BI Service with Schedule Refresh?

@v-yulgu-msft.

 

Recreating the multi-row card and also trying a common card visual did not work again. When I publish for the first time, it shows the corret value, after the schedule refresh it turns 0.

 

Any idea why?