error with tabular measures in powerbi.com

[FrankK]

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(DimSalesChannel[SalesChannelDesc])="CertifiedPreOwned"),[Vehicle Counts])

I can see the measure and use the measure in Power BI Desktop. I can also publish the report succesfully.

When I go to the PBI service and I click on the report, I get an error for the visual

For the life of me I cannot figure out what the PBI service has an issue with. Anyone else running into this? It also happened on a calcualted column I added to my DimDate table (simple concatenation of values)

[FrankK]

Just to update, I set the measure = 1 and I still get the same results in the PBI.com site.

I also noticed that PBI.com is not even showing the measure...but I can see it in the PBI desktop app

[nikil]

Not sure what the reason is. Try to contact support team (https://powerbi.microsoft.com/en-us/support/)

Thanks

Check out Chicagoland Power BI User Group

[FrankK]

The problem seems to have resolved itself. PowerBI.com is now seeing my new measures from the cube.

Odd...

Frank

[Seth_C_Bauer]

@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]

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