Power BI dataset parameters in Excel

[C4L84]

Hi Community - hopefully this is the correct place for this question.

I've connected to a Power BI dataset in Excel, how do I edit the dataset parameters in Excel?

[C4L84 · Accepted solution]

OK, I've submitted to Power BI ideas - thanks

[v-cazheng-msft]

Hi @C4L84 ,

I haven’t found an option to edit Power BI dataset parameter in Excel. It should haven’t been supported. You may consider submitting need in Power BI Ideas where the product group collects suggestions from users. Here is the link of Power BI Ideas: Ideas (powerbi.com).

For parameter defined in Power Query Editor(Transform Data) of Power BI Desktop, you could edit it by going to the Settings page of the dataset and change the parameter there. Then, you could try reconnect to the dataset or refresh the content in Excel.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun