Forum Discussion
Adding INFO.VIEW.COLUMNS() to Model causes refresh error
Hi. Please try adding the code to another semantic model to verify if there is something odd about the model. According to the docs, you can use them in a calculated table and it will refresh.
https://learn.microsoft.com/en-us/dax/info-view-columns-function-dax#remarks
Let's try that to check if there is something else at the model.
Make sure the owner is also a workspace admin just in case, because this is written too: For Power BI semantic models, just like DMVs, the INFO DAX functions require semantic model admin permissions. Some also require workspace admin permissions.
I hope that helps,
Hi. Please try adding the code to another semantic model to verify if there is something odd about the model. According to the docs, you can use them in a calculated table and it will refresh.
https://learn.microsoft.com/en-us/dax/info-view-columns-function-dax#remarks
Let's try that to check if there is something else at the model.
Make sure the owner is also a workspace admin just in case, because this is written too: For Power BI semantic models, just like DMVs, the INFO DAX functions require semantic model admin permissions. Some also require workspace admin permissions.
I hope that helps,
Hi ibarrau,
thank you very much. I did re-factor my code for INFO.VIEW.COLUMNS() a little bit:
Info View Columns =
// Select specific columns from the filtered result
SELECTCOLUMNS(
// Filter columns from the INFO.VIEW.COLUMNS() table
FILTER(
INFO.VIEW.COLUMNS(),
[IsHidden] = FALSE()
),
// Show only these selected columns with new names where specified
[Table],
"Column", [Name],
[Description],
"DAX formula", [Expression],
[DataCategory],
[DataType],
[IsHidden]
)
This seems to work now without effecting the successful refresh.