Forum Discussion

C4L84's avatar
C4L84
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Power BI dataset parameters in Excel

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?

2 Replies

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support

    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

  • C4L84's avatar
    C4L84
    Icon for Advocate II rankAdvocate II

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