synapse datalake .parquet files tot feed into power bi report

arkiboys 9,646 Reputation points
2021-07-31T05:55:44.02+00:00

Hello,
Using the synapse pipelines, I have transferred onprem sql server data into .parquet files.
Using the serverless sql pool, I have created views which read the .parquet files...
The power BI reports are to call the views to get data.

Question:
Is this a good design? is it best to use Azure sql server to hold data instead of the .parquet files ? so that then power BI reads from the tables in Azure sql server?

Thank you

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,447 questions
0 comments No comments
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-08-03T00:40:44.373+00:00

    Hello @arkiboys ,
    Thanks for the ask and using the Microsoft Q&A platform .

    Power BI reports can read data from both the data source , but it all depends how your enterprise consume data . I think using serverless is better option ( if its in your ecosystem) as you only pay for the query execution time .

    Please do let me know how it goes .
    Thanks
    Himanshu
    Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    0 comments No comments

0 additional answers

Sort by: Most helpful