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
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
