Forum Discussion

TroyStory's avatar
TroyStory
Regular Visitor
6 years ago
Solved

How can I build a data warehouse?

Hi All, looking for some guidance on the way to approach the below.   I had previously built a report that was importing data from excel spreadsheets to a report that was published in the powerBI s...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    I know very little about actual data sync. MS has a tool for this, and I know there are third party tools to sync between various data sources, like SQL, SharePoint List, etc. to Azure. You'd just need to do a bit of searching, or head to the Azure community on the MS tech forums. I know someone there will have hands-on experience with this and can assist.

TomOs's avatar
TomOs
Resolver I
1 year ago

Choose a data warehouse like Azure Synapse, Snowflake, or Google BigQuery. To extract data from SQL, use an ETL tool to automate ingestion and transformation, like Skyvia. It provides a no-code solution for integrating these sources into a centralized warehouse with automated scheduling.

 

Once the data is in place, connect Power BI via DirectQuery to improve performance and avoid refresh issues.