error with tabular measures in powerbi.com

Question

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)

anonymous · Answer

FrankK&nbsp;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 · Answer

Just to update, I set the measure = 1 and I still get the same results in the PBI.com site.&nbsp;I also noticed that PBI.com is not even showing the measure...but I can see it in the PBI desktop app

nikil · Answer

Not sure what the reason is. Try to contact support team (https://powerbi.microsoft.com/en-us/support/)&nbsp;ThanksCheck out&nbsp;Chicagoland Power BI User Group

frankk · Answer

The problem seems to have resolved itself. PowerBI.com is now seeing my new measures from the cube.&nbsp;Odd...&nbsp;Frank

frankk · Answer

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.&nbsp;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.&nbsp;Who knows...just one of those wierd things...&nbsp;frank

Forum Discussion

error with tabular measures in powerbi.com

5 Replies

Related content

Tabular measure.

Enable Discouraged implicit measures without tabular editor

How to Re-Enable Implicit Measures Without Tabular Editor?

Windows defender blocking Powerbi.com

Process Tabular model