Moving Measures in a separate table (PBI & SSAS 2017 Live Connection)

[Anonymous]

Hi,

I’m using SSAS 2017 to store my tabular model.  As frontend I’m using Power BI Desktop Release March 2018.

Because in the meantime I have a huge amount of measures (stored in SSAS 2017 tabluar mode) I want to  structure and group them. Of course I could use display folders but I would rather prefer to a separate “measure table”.

From the PBI Desktop I already know that measures are “table inspecific”, so they can technically live anywhere. Furthermore, I know how to move measures between tables (or to a specific measure table) easily as shown here.

But as far as I experienced it with the tabular model in SSAS this easy way is not possible. In fact, I have to cut out the measure from one table and paste it into the new location/table. Thus, actually I have to recreate them.

The disadvantage accompanied by this approach is that the connection to the moved measure gets lost in the PBI Desktop and I receive and error in my PBI report that the measure is not available anymore.

Is there any other way to move a measure in SSAS 2017 in the way you can do it in Power BI Desktop?

Thanks a lot.

Best regards,

Dom

[v-yuta-msft · Accepted solution]

Hi DomPower,

This issue seems like more related to SSAS, I would recommend you to post your issue in MSDN SQL Server forum here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices.

Regards,

Jimmy Tao

[Anonymous]

Hi @v-yuta-msft,

Thanks for that hint. I posted my question there. See https://social.msdn.microsoft.com/Forums/sqlserver/en-US/72eab266-dd22-4711-9fbd-017430fd6e70/moving... .

Cheers,

Dom