Forum Discussion
Adding INFO.VIEW.COLUMNS() to Model causes refresh error
Hi,
I tried to publish a Semantic Model with a new table using "INFO.VIEW.COLUMNS()". Unfortunately the Semantic Model is not refreshing anymore after pubishing. I'm getting the following error:
"An unexpected exception occurred. The current operation was cancelled because another operation in the transaction failed."
After removing the table the refresh is working again. The other INFO.VIEW tables (e.g. INFO.VIEW.RELATIONSHIPS) are working fine.
Datasource is Snowflake Cloud.
Thanks
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,
4 Replies
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.
Does the refresh still work in Power BI Desktop but fail only after publishing to the Service? That’s usually a sign of metadata or connector-related issues. In SAP InfoViews, this can happen if certain fields have metadata (like units or hierarchies) that Power BI Service doesn't handle well.
Try removing just the new columns and test again. If it works, reintroduce them one at a time to isolate the problem field. Also check if you’re using a gateway with the right credentials and driver versions.
Hi christian_cw_wo ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
