Power BI App solution

[kamilczekajlo]

Hi everyone,

In my company I'm responsible for creating the application in Power BI for external clients.

The App is to be published on AppSource - I know the whole process of creating Template App Workspace,'Create App' and then 'Promote App' etc. (I'm aware about all requirements related with Partner Center Account etc)

I have a problem with architecture (type of connection, suitable solution)

Raw data comes from Microsoft Dynamics NAV. Then I have DWH on the SQL Server based on Databases from NAV with ETL process between them. 

I need to use TABULAR or OLAP cube dedicated to the specific report in Visual Studio and then use the cube data in Power BI Desktop to create the Report and add this to the content of Template App Workspace.

As far as I know,

 - The Power BI App does not support LIVE CONNECTION using in Power BI Desktop, so I cannot use this type of connection to the Cube in Power BI Desktop, right?

- If I use Import mode in Power BI Desktop, what types of connections with DWH (Sql Server) are available in the CUBE - Direct Query and Import or only Import?

I must have the best performance solution in my app promoted to the AppSource.

I will only add that I tried to connect to SQL Server directly in Power BI Desktop but My Boss doesn't want to use this 'DirectQuery' type solution in our app.

We have similar DWH on the Azure SQL Database - maybe it will be helpful in another solution.

Thanks in Advance for any help!!

Best, Kamil 🙂

[V-lianl-msft]

Hi @kamilczekajlo ,

If you are using SSAS Tabular you unfortunately have to use an AD Account for external users. And then map them in the On-Premise Gateway.

The reason for this is that the SSAS Tabular is not connected to AAD, it only connects through the local AD domain. So in order for an authenticated user to pass, it must ensure that there is an account in the AD domain.

If the azure analysis service you are using is suitable for the above example, it is because it is using azure ad.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kamilczekajlo]

Hi @V-lianl-msft ,

Thank you for your response. I appreciate this.

I'm aware about mapping Accounts for external users in the On-Premise Gateway.

I'm not sure that I understood correct.

I need to know what type of connection to use in each of the steps, so that the performance is the best 

and that it is possible to upload the application to appSource at all.

In SSAS Tabular Cube should be: Import or Direct Query to connection to SQL server database?

In Power BI Desktop should I use: Import or Live Connection to connection to SSAS Tabular Cube?

Or maybe should I use another architecture? Maybe Azure Analysis Services Tabular Model or directly connection between SQL Server Database and Power BI using DirectQuery mode?

Best regards,

Kamil