Does executing a view in serverless SQL in azure synapses analytics through power bi will charge for eact query execution ?

Question

I have Dynamics 365 FO data stored in azure datalake and created a view in synapses analytics serverless pool for each table in the datalake . I am connecting the synapses data to power BI for reporting . I would like to know if microsoft will charge for each query execution from synapses while reporting or its only for the storage . As of now I don't have any pipelines or dataflows created . Please help . Thank you

Answer 1

Hi, Yes. From power BI if you are running a query , it will incur the same cost as we run from synapse pipeline or workspace. It is all about data being processed by the query irrespective of from where we run them.

You need to pay for executed queries and the pricing varies based on the amount of data processed by each query. A minimum charge of 10 MB is applicable for each query and it is rounded up to the nearest 1 MB. There is no cost for DDL statements.

Per TB it costs $5. Hope that helps! Please let us know for any further question on this.

Answer 2

Athira Reghuraman - Thanks for the question and using MS Q&A platform.

Yes, you will be charged for each query execution from Synapse while reporting. However, the charges for each meter are summed at the end of your billing cycle.

In Azure Synapse Analytics, executing a view in serverless SQL through Power BI will result in charges for each query execution. Azure Synapse Analytics charges based on the amount of data processed and the number of queries executed. Even though you are not using any pipelines or dataflows, every time a query is executed against the data in your Synapse workspace, it is counted as a data processing operation.

Therefore, when you connect your Synapse data to Power BI for reporting and execute queries against the data stored in Azure Data Lake, you will be charged for each query execution based on the amount of data processed by the query.

To optimize your costs, you can consider using features like query caching and query optimization in Azure Synapse Analytics. Additionally, you can also explore options like creating materialized views or using Azure Analysis Services to reduce the number of queries executed against your Synapse workspace.

For more details, refer to Plan and manage costs for Azure Synapse Analytics.

Hope this helps. Do let us know if you any further queries.