Modify a query

[bebeto]

Why sometimes I can't modify a query?

There are queries that, when I select them, it appears "Cube settings" in my panel:

But there are other queries that it doesn´t appar and I don't know how to add a new column from my cube.

[Haegi · Accepted solution]

Hello,

All of your queries provide from a cube (ssas for example) ?

The cube system is a specific data model and type of connector.

[Borntoreport]

Hello,

I had the same experiences already a view times. Different queries are open and it is no longer possible to modify them with "cube settings". Thank you for your answer Haegi, but for me the problem is not solved. I can add new columns for calculations and open new queries, but it is not possible to add new data in an existing query. Why?

[Haegi]

but it is not possible to add new data in an existing query. Why?

I don't understand because the ssas connection is as dynamique connection i think.

When your data in the cube changes (insert or update) if you refresh your queries in pbi desktop they are up to date.

Regards.

[jessem]

This has happened to me as well. Does anyone have a solution?

[pqian]

@jessem & @bebeto,

The Cube transformation menu is only available when your query is fully folded to be executed on the server. If a local transformation is involved, then we break out of multidimensional mode and you are only dealing with a tabular model from then on.

You can always add more items by double clicking the "Added Items" step instead. 

Another note: the top left corner of the table gives a hint of the "cubeness" of the query:

Left one is Cube, right one is table