Switch Power BI data sources from Excel to Azure analysis services

Question

Right now I have created power bi dashboard (using power bi desktop) which retrieves data from excel file. Later on I will replicate the same data model to Azure analysis services tabular model.

Is that possible?

Answer 1

One option that you should consider would be to have the SSAS Tabular cube readily loaded using the data from the excel and you start off the development of Power BI. That way source changes in Power BI will not be an issue going forward.