Forum Discussion

FrankK's avatar
FrankK
Icon for Advocate I rankAdvocate I
10 years ago

error with tabular measures in powerbi.com

I have a SQL Server 2014 Tabular model connected to PBI through an enterprise gateway.   I have created a simple SUMX measure in my tabular model   SUMX(FILTER(FactVehicleCounts,RELATED(DimSalesC...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

FrankK Was it a new measure or a measure that you changed? I've had issues where there seemed to be a delay for existing model elements being actually updated in the Service. Usually it was just a matter of giving it a little time between last process and hitting the reports right away.

FrankK's avatar
FrankK
Icon for Advocate I rankAdvocate I
10 years ago

it was a new measure. I thought it was just a delay as well but I actually refreshed the report in PBI Desktop first, saw the measure, used the measure in a visual and then published the report. That typically refreshes the dataset on PBI.com right away. I went back and forth with this for over 20 minutes before I threw in the towel.

 

This morning I came in, hit the PBI.com site and my measure was there. Since this morning I have had no issues adding measures and the PBI.com service seeing the measure within a minute or so.

 

Who knows...just one of those wierd things...

 

frank