Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Unable to create table in tabular model that I previous created in the desktop app

We wanted to move away from bookmarks and into field parameters to control some changes to visuals on one of our reports. When a user selects an option from a drop down I want it to change all the visuals to show data related to the option they picked. I was able to get that all working in PBI Desktop by building the following table

 

Field Parameter = {

    ("Overall", NAMEOF([MSV None Field]), 0),

    ("LOB", NAMEOF('Term'[LOB]), 1),

    ("Segments", NAMEOF(‘Term'[Segments]), 2),

    ("Industry", NAMEOF('Term'[Industry]), 3),

    ("Product", NAMEOF('Product'[Product]), 4)

}

 

Everything was working fine. I published the report to the service and a couple months later noticed the report was no longer refreshing data and we were receiving an error that stated "Refresh not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery". I thought this was due to some measures I  created in the desktop app using CalculateTable, so I rebuilt those in the tabular model but still receiving the error. I then figured it had something to do with my feld parameter table above, so I deleted it from the model in the desktop app and I was able to publish and refresh data. So I think I need to get this table recreated in the tabular model, but when I enter it exactly as above (minus the name, since it says it has to start with an = sign) it tells me the formula has an error. It seems to not be recognizing the tables/columns referenced, but those tables and columns are all already in the tabular model, with the exception of the MSV None Field which I tried removing and still the table will not build correctly. I even tried building it without the NameOF before them but it still did not recognize them.

What do i need to do to recreate this table in the tabular model? I am using tabular model explorer in visual studio if that makes a difference. Is there another way to make this all work without rebuilding the table in the tabular model? Any other options I should try? Thanks!

1 Reply

  • Instead of 

     

    NAMEOF([MSV None Field])

     

    use

     

    "none"