Hi @2JK ,
Thank you for posting query in Microsoft Q&A Platform.
Yes, as you are guessing "Azure Synapse Analytics" is best option to go with.
Q. I want to have a DirectQuery connection to Power BI.
A. This is very much possible with Synapse. We can connect a Power BI workspace to an Azure Synapse Analytics workspace to create new Power BI reports and datasets from Synapse Studio. Click here to know more about it
Q. Synapse should support many linked services.
A. yes, Synapse supports many connectors. To know the full list of connectors Click here.
Q. Synapse can ingest, store, process and output your data?
A. Yes, Synapse can be used to ingest, store and process and output your data.
Synapse Pipelines - can be used to ingest, output data.
Synapse SQL & Synapse Spark - can be used to process or transform your bigdata at scale.
Dataflows - can be used to process or transform your data without even need to write code. You can implement your transformation logic in GUI fashion.
Q. Synapse handle very large data?
A. Yes, Synapse can handle huge data.
Q. Assuming we go for Synapse, the historical data still be archived in Blob storage, correct?
A. yes, Its very much possible. You can have a Synapse Pipeline to archive your historical data to Blob storage.
Please Note, you can use Azure Stream analytics also to stream data in to Azure Synapse. Click here to know more.
Hope this will help. Please let us know if any further queries.
- Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators