Hi two questions on Analysis Tabular Connection

[Gregs138]

1. When I change the underlying tabular model in SSAS, what can i do to get Power BI to recognize the changes?   When I click refresh it says I don't need it, and if I try to connect to the tabular model again, it simply creates a second instance of the model in poewr BI.

2. Are you planning on supporting hierarchies from tabular model?  Currently I have no visibility on my drilldown hierarchies from my tabular model.

TY

[andre · Accepted solution]

Your changes to the AS models should get recognized automatically.  You may have to manually refresh the page to make sure that nothing is being cached but if you add a new measure to your model it will show up in the dataset automatically.

There were a lot of posts on hierarchies and drilldowns on this board and the official answer from Microsoft is that it's being worked on right now, but there is no ETA at this point.

[andre · Accepted solution]

Your changes to the AS models should get recognized automatically.  You may have to manually refresh the page to make sure that nothing is being cached but if you add a new measure to your model it will show up in the dataset automatically.

There were a lot of posts on hierarchies and drilldowns on this board and the official answer from Microsoft is that it's being worked on right now, but there is no ETA at this point.

[Gregs138 · Accepted solution]

TY much.  I can live wo the Hierachies for the moment, with these smaller "widget" type controls, you can simulat drill down by jumping from dash board to report.  it is not a deal killer in this environment.

The automatic model refresh it seems to be on a timer or something.  Page refresh doesn't force it, nor does logging out and back in.  Not sure what triggers it.

I can confirm though that it does eventually update, so thanks for pointing that out.  It's not too big of a deal, but when you are bulding a new model and doing quick back and forth testing it makes it a little cumbersome.