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...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
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

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

    Anonymous For refreshing the dataset i could use the gateway, right? If I decide to use the import mode.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      haassiej，

      For Azure Analysis Services data source, gateway is not required when you refresh the dataset.

      Regards,
      Lydia