Changing Excel parameters from Power BI

[sv12]

Hi,

I have an excel sheet with all the calculations populating my data.

Is there a way to pass in a value for a variable/parameter to excel from power BI; and get the data recalculated?

Any help would be appreciated!

Thanks

[v-lili6-msft]

hi, @sv12 

If you try to use Parameters in Power BI:

https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

Best Regards,

Lin

[sv12]

Hi @v-lili6-msft ,

Is there a way to feed excel calculations with Paramters in Power BI? Or do we have to recreate all the calculations in Power BI to achieve it?

[v-lili6-msft]

hi, @sv12 

If you need Import Excel workbooks into Power BI Desktop?

https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

Otherwise you need recreate them.

Best Regards

Lin