Hi All,
Just wondering what you found to be best practice when creating a PowerBI dashboard from hard coded excel files.
In short I have to create a new dashboard with work, but the data i have to use is a hard coded table which is updated weekly by simply inserting a new column every week. Is there a way to condese this into a better format? I have attatched a mock up example of the data below with some fake figures.
Any help at all is very much appreciated, thank you.
Hello @Kieran-q_20 ,
the best practice is to build the Power BI Model as a star schema,
check it out here https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! |  |
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
