Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |