question

arkiboys avatar image
0 Votes"
arkiboys asked HimanshuSinha-MSFT answered

synapse datalake .parquet files tot feed into power bi report

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.