What is the best way to transform raw data coming from synapses to Power BI

Athira Reghuraman 60 Reputation points
2023-07-19T10:21:43.7766667+00:00

I am into a project to bring all data from F&O to synapses and then load to power BI to create multiple dashboard for different modules and it will be used by different companies . So I would like to understand what will be the best platform to transform the raw data for high performance.

Thank you,

Athira Reghuraman

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
429 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,148 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 37,236 Reputation points Microsoft Employee
    2023-07-20T14:01:45.1933333+00:00

    Hi Athira Reghuraman,

    Thank you for posting query in Microsoft Q&A Platform.

    You can consider having Synapse pipelines which are similar to ADF pipelines to take data from your source. Inside the pipelines you can consider having Synapse notebooks to transform your data and finally load the transformed data in to Synapse SQL tables. And then finally PBI can consume data from there.

    Hope this helps. Please let me know if any further queries.


    Please consider hitting Accept Answer button. Accepted answers help community as well.


0 additional answers

Sort by: Most helpful