Forum Discussion

haassiej's avatar
haassiej
Icon for Helper I rankHelper I
8 years ago
Solved

Multiple PBIX files or a tabular analysis cube?

Hi everyone,   I have a question regarding the use of separate PBIX files or the use of a Microsoft Analysis Service CUBE. I work with various financial subject areas. As an example: Cost Analysis...
  • Anonymous's avatar
    Anonymous
    8 years ago

    haassiej,

    Do you use Azure Analysis Service? If that is the case, please note that refresh model on Power BI Service with Azure Analysis Service data source in import mode is not supported. If you want to refresh the dataset in Power BI Service, you would need to use "Connect Live" mode to connect to Azure AS in Power BI Desktop.

    Moreover, personally, I prefer to have a single Tabular model and create report connecting to the model in a single PBIX file, which is more easy to manage comparing to multiple PBIX files.

    Regards,
    Lydia