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...
Hi Lydia
Building a data model in PowerBI Desktop sounds good, but
if I want to create different projects on this model, how can I resuse it in other PBIX?
Like a single source data model?
Wouldn't it be better to create it in Excel and then use it in both, PowerBI Desktop and PowerBIService?
ajourneyinto,
Firstly, you are able to connect to different sources in a single PBIX file.
Secondly, you can connect to Excel file in Power BI Desktop following the guide in the article when you put Excel in OneDrive for business.
Thirdly, after you publish PBIX file to Power BI Service, you are able to connect to the dataset from Excel using "Analyze in Excel" feature.
Regards,
Lydia