Share via

How to create a model in Azure Synapse such that data can be ingested from any data source to this model?

Divya Charita 1 Reputation point
2022-01-31T10:46:43.957+00:00

I am new to Azure world. I have a scenario where I would like to create a tabular Data Model in Azure and access this Data model from Power BI. Data would be populated in this model via Excel but I would like to link it to a service later.

Basically, could anyone please let me know how to create a uniform Data Model where the data sources can keep on changing.

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.
5,378 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2022-02-01T11:40:25.793+00:00

    Hi @Divya Charita ,

    Thank you for posting query in Microsoft Q&A Platform.

    You can consider using Synapse or ADF for ETL purpose to take data from different sources to your Datawarehouse. Once data loaded to Datawarehouse you can initiate tabular model data injection process. Synapse pipelines and ADF supports excel format data.

    Please let us know if it helps. If my understanding of your ask is incorrect then could you please share more details about query may be with sample example scenario? so that its more easy to share thoughts. Thank you.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.