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 :
When I want to use Power Query I get this error message, what should I do?
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.
- How to apply RLS to other dimensions when using the static RLS approach?
- How to join columns from different tables and insert a calculated column in PowerBI / Power Query
- What does it mean by Power BI report references a row with RLS?
- Power BI - Dynamically generate queries
- Getting the next value of the same user if the type is "no type"
- Add a new column from value that is stored in a list of cell of the table
- Power Bi - Change font color of text in Matrix Visual
- PowerBI filtering rows from table visual when values are missing
- Developing PowerBI Visuals
- How to replace the value in same column - PowerBI query editor
- Unable to connect python script in PowerBI
- Combining Rows in Power BI/Power Query
- Eliminate customer with less than 2 products from the List
- How to filter a table based on a particular date in power BI
- MoM comparison on Area Chart results in +1 day
- DAX filter a Measure by an other Measure
- count distinct of 2 modalities at scale
- How to Set Default Collapsed State in Deneb-Vega Gantt Chart for Power BI
- Power BI calculate Measure for previous working day
- Calculate first date similar to sql window function in DAX
- User doesn't have permission to call the Discover method
- Changing the Color of a Set of Bars of a Clustered Column Chart
- Combining Measures from different Tables
- Distinct Count Rows with filter on Same column with Multiple Rows
- Configuring PowerBI on-premise gateway for SQL Server
- Creating a Music Podium top 5 - like visualization in Power BI from a table
- Using DAX to create a dynamic horizontal line for a bar or line chart in Power BI
- TypeError: Cannot read properties of undefined (reading 'tokenType')
- Sort Text Numbers in ascending in Slicer
- How to lookup Grades corresponding to Marks scored by students from a Grade-Slab table in Power BI?