Forum Discussion
Best practice: How to build data model with Excel
Hi What's the Best Practice to build a data model? Would like to build data model in Excel in order to use it on different Reports in PowerBI Would like to use PowerBI online and PowerBI Desktop i...
ajourneyinto,
Why not directly build data model in Power BI Desktop, then create reports there and publish PBIX files to Power BI Service?
In addition, if you persist to build data model in Excel, what option would you like to use , Power query or PowerPivot? I would recommend you post questions in the following relevant forums.
Power query
Powerpivot
Regards,
Lydia
the idea would also be to create just one data model (as it might be complex) also for further use in other Excel Dashboards...