Forum Discussion
Missing measures with live SSAS MD
I'm having problems when publishing a PB Desktop report on a live SSAS MD connection on app.powerbi.com. Some of my calculated measures are missing in the published dataset.
I updated the enterprise gateway to the latest version and PB Desktop as well (May update).
I'm unable to find a reason since some of the calculated measures using pretty much the same pattern are shown.
Well, I added some new measures in my cube and got the same problem. I didn't found out the reason but found a quick workaround.
1- Stop the Enterprise Gateway
2- Publish the report to update the dataset
3- Open the report on the web until I got an error message about gateway not available
4- Start the Enterprise Gateway
5- Select the gateway in the report
Maybe using only steps 1,2 and 4 would work. Not sure. I'm pretty sure it's related to the update MS did a couple of months ago giving the ability to query reports while being offline. Something is kept in the cache of powerbi.com and it seems that the update to a dataset (here SSAS MD live) are not taken directly (or with a delay).
5 Replies
Well, I added some new measures in my cube and got the same problem. I didn't found out the reason but found a quick workaround.
1- Stop the Enterprise Gateway
2- Publish the report to update the dataset
3- Open the report on the web until I got an error message about gateway not available
4- Start the Enterprise Gateway
5- Select the gateway in the report
Maybe using only steps 1,2 and 4 would work. Not sure. I'm pretty sure it's related to the update MS did a couple of months ago giving the ability to query reports while being offline. Something is kept in the cache of powerbi.com and it seems that the update to a dataset (here SSAS MD live) are not taken directly (or with a delay).
I tried creating a new cube based on the same but I deleted nearly all my calculated measures. I only kept one of the missing calculated measures. I created a new report based on this new cube and publish it. Guess what, the calculated measure is now there.
Is there a limit on the number of measures in a cube?
Anonymouswouterzijlstra I've seen this behavior periodically where there is a delay in the model measures being added to the dataset. I would recommend deploying the model as you want it, and checking back a bit later to see if it has updated. This is by no means accepting that this is acceptable behaviour, but I would be interested in knowing if it eventually shows up (as I've experianced) or if it doesn't show up at all.
I have the same problem today. Created a new meassure in an existing SSAS Tabular model, changed the Power BI Desktop report en published it the Power BI service... The new meassure doesn't appear.
I think this is more of a bug in somewhere in Power BI (gateway or service) where the model structure won't refresh. Perhaps it will appear tomorrow.
"Please click the Accept as Solution if this resolves your issue; if it did not resolve your issue, provide more information on what happened instead.".
Thanks for all your answers guys. I think I tried everything (reinstall gateway, drop and replace the SSAS db, restart the server) without any success. It's now working though...
Don't know if it's a delay problem in the metadata refresh but they only thing I did is published the report (and dataset) while the gateway was stopped. When I started the gateway, my missing measures appeared...
Maybe it's a cache issue because like I said before, I was able to show those measures when publishing in a new SSAS db.
