Forum Discussion

christian_cw_wo's avatar
christian_cw_wo
Frequent Visitor
1 year ago
Solved

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: ...
Need Help
  • ibarrau's avatar
    ibarrau
    1 year ago

    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,

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi christian_cw_wo 

 

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.