Forum Discussion
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
- lbendlin
Super User
Instead of
NAMEOF([MSV None Field])
use
"none"