Can we pull a parameter in Spreadsheet which is in a Dashboard ?

I believe this is what you're looking for: 

Can Parameter Prompts be Removed When the Cube View is Opened in Excel?

Authored by Paula Mihalko

Question

If you have a cube view that has a prompt (say for Entity) and you open the cube view in Excel, every time you refresh the prompt will pop up.  Is there a way to "remember" the selection for that parameter or otherwise remove the prompt?

Answer

Yes, by setting up a NAMED RANGE cell with the same name as the parameter.  

Example cube view - note there's a prompt for the Entity:

Open the Cube View in Excel

By creating a Cube View Connection

Here's what the Cube View looks like: 

To "replace" the need for the prompt, add a single cell named range with the same name as the parameter:

Then when the sheet is refreshed, there's no popup for the parameter.