Power BI Reporting cost optimization

[Anonymous]

We have a reporting solution wherein we transfer data from multiple databases to a single Azure SQL database, which is migrated to Azure analytical services, that are then used to generate the Power BI reports. These reports are embedded into a web application using Power BI Embedded.

Given the license cost of analytical services and power bi Embedded licenses, the overall cost of the solution comes to USD 2500, for the configuration below.

Azure App Service - B1 - USD 55

Azure SQL Database - S3 - USD 172

Azure Active Directory - Basic - USD 1.5 for a single user

Azure Data Factory - USD 150

Power BI Embedded - A1 - USD 700

Azure Analysis Services - B2 - USD 600 

As you may see, this is the cost when I have used only the first pricing tiers for my solution. The count of my customers will be in single digit for the foreseeable future, the cost per user is currently quite steep.

I am looking for references and suggestions that can help bring down my solution's overall cost. Thank you for your help.

[v-jiascu-msft]

Hi @Anonymous,

I think that all depends on your needs. For example, the number of end users, the size of data. Just see from your list, if it's possible to do all the analysis work in the Power BI instead of Azure Analysis Services.

Best Regards,

Dale

[Anonymous]

Hello @v-jiascu-msft,

Thanks for your feedback. We worked on the feedback that you have provided and below are the results.

We are having a large amount of data and there is a limit that max file size uploaded to power bi services is 1GB so I think we can't move our analysis part to Power BI. And We also thought about using Direct Query Mode but that also resulted in the performance degradation.

Kindly suggest if there is some other part where we can save our costs.

Thanks,

Ankit