Forum Discussion
Solved
Use Excel or Power BI to transform data for reports
I have used PowerBI to create reports quite a bit, but with simple one-table models. I did all my transformations in Excel each week, mostly with formulas keeping the same table name (I don't know ho...
OMG. I just figured it out on my own. All I would have ever had to do for the past year and a half when I was working on the other dashboard and now this one is (wait for it) hit Refresh. I can't believe all the gyrations I was going through to update the data. Well, better late than never?
Thanks!
Cheryl
lbendlin
Super User
Super UserAre you ready to move on from your single-table models to more complex data models with multiple tables and their relationships, ideally in a star schema?
Which of your tables have content that changes slowly or never?
What kinds of transforms are you doing in your Excel files?