undefined

[Anonymous]

Hello!

I have an Excel file meant to mock the structure of a business. It has different departments, and then unique products that each department offers. I want to be able to go into Excel, add a department or product, and have it reflected/updated in a bookmark, or drop-down list.

If there is a better way I can explain, or something that's confusing, please let me know.

Any help is appreciated - thank you!

[MFelix]

Hi @Anonymous ,

If you have PBI datasource linked to the excel file, you are abble to add different information to your excel file and then have it reflected in your PBI after refresh.

Not sure how you have everything setup but assuming that your products or departments are in different tables if those tables are connected to PBI when you update excel the new information will be updated.

Can you share a sample file and mockup of your files?

Regards,

MFelix