Power Query (Power BI) SQL Server Analysis Service / Cube Tools (Add Items)

[MrDaniels]

Hi gurus,

Im conencted to a  Sql Server Analysis Service (Cube), when I go to power query to bring the columns I need, if I change type or add custom column, then I cannot add another step for adding Items from the cube. Literally I have to go back to the previous step (Add Items) then add those columns I want to add.

IS there a way to add another step to add items from the cube, after starting to modify the data loaded in the previous steps?

As you can see, after changing the type, I cannot add another step of Added Items.

How can I go back to this menu to add the Added Items Step:

Thanks in advance!

MrD.

[freginier]

You can't add after this step.

You can add all your fields and then remove when you want (not recomended)

______________________________________________________

If you found this post helpful, please give Kudos C

[MrDaniels]

Thanks for your message.

Unfortunately I cannot do this because we are talking about a very large number of tables and fields.

Hopefully a feature they will develop in the future.

Cheers.