synapse datalake .parquet files tot feed into power bi report

Question

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

Answer 1

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