Dashboard that runs a spreadsheet with a combo box error

[OSAdmin]

Originally posted by Andrea Tout

6/26/2018

Hey there! I am trying to do a spreadsheet form. So the form template is built as a dashboard because if you build a spreadsheet form, any prompts will show up as a dialogue, not be nested on top of the form. So instead I am making a dashboard that runs the spreadsheet with a combo box. It works for the most part, but every time I run it I get this error, but when I make a selection, in the combo box, it all runs fine. Has anyone seen this? I want to try this for my users but the error makes it look wonky.

[OSAdmin]

Originally posted by Andrea Tout

It is actually the first time that a user logs in! So it doesn't error out when they log out and log back in or change months or anything.
But I did find the KB article in teams and it worked like a charm to nest the parameter in the spreadsheet. It was very easy too, you just place a cube view with the potential selections on one sheet, set up a list in excel that uses the rows, and then nest the parameter (without pipes and exclamation points) in the named range of the list.