CODEWITHSUNDEEP
powerbipowerqueryazure-analysis-services
Theo27
Theo27

Reputation: 405

How to modify the properties of a SQL Server Analysis Services database field in Power BI?

I am working with Power BI on a model that is a cube of a SQL Server Analysis Services database.

When I go to the model view and select a field from a table in my model, I would like to be able to modify these properties but the fields remain grayed out as in the picture below : enter image description here

When I want to use Power Query I get this error message, what should I do?

enter image description here

Upvotes: 0

Views: 547

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40224

This is not possible with the way you are connected. You are connecting to SSAS rather than building a model yourself, so any modifications would have to be done to the SSAS rather than locally.

Fortunately, there have been recent updates that allow you to change the connection type to a DirectQuery which allows for local modeling. It's still pretty new, so there are still some limitations and rough edges.

Upvotes: 1

Related Questions