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