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! |  |
