Webapp to extract Excel data

Question

Hi there - I am trying to create a database from existing Excel model files, and then access the data through webportal or through PowerBI.

Unfortunately the data is not currently structured as a table and these files are fairly complex. Could I please get help with this? I know I am new to Azure, and that this is likely a paid requirement, but happy to use the provided Azure credit or at least understand how difficult this would be to pull off.

Best,
Nick

Answer 1

Hi @Nicholas Ahn ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

• Extensive list of Azure architectures that are suitable for various scenarios are available here and will be useful to begin understanding the components that can be used - architecture
• A great video that shows loading of unstructured data using data factory and visualizing it in Power BI - watch
• Videos and tutorials from Azure site would be great to start with azure services - Azure videos, ADF videos

Hope this helps! Please let us know for further queries and we will be glad to assist.