Synapse Analytics with sharepoint data integration for PowerBI Analytics

Satoshi 1 Reputation point
2020-10-08T03:41:45.987+00:00

I'd like to analyze the data on Synapse imported from excel file on Sharepoint by PowerBI.
How can I import the excel file from Sharepoint into Synapse?

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.
4,258 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,412 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Itch Sun-MSFT 2,556 Reputation points
    2020-10-08T08:07:56.15+00:00

    Hi @Satoshi

    As far as I know, Synapse Analytics does not support the data format of excel, and we cannot import excel files into Synapse Analytics.

    For how to import data into Synapse Analytics, you can refer to the following article:

    https://learn.microsoft.com/en-us/learn/modules/import-data-into-asdw-with-polybase/

    https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments