Forum Discussion

SarWal's avatar
SarWal
Microsoft Employee
10 years ago
Solved

Import Data from Excel sheet in SharePoint

Hi Power BI Community,   I am new to Power BI and hoping to get data for Power BI Desktop from an excel that lives on SharePoint.  I tried to Get Data -> SharePoint Folder, and then entered the ...
  • SamLester's avatar
    SamLester
    10 years ago

    You can get the contents of the file (as opposed to the metadata) by editing the data source during import. In the query editor window, there will be a column labeled Content, along with an icon that appears to be two down arrows. Click on the icon and you'll add the actual content as opposed to the metadata.

     

     

     

    The process is similar when you "Get Data" from a Windows folder containing spreadsheets. By clicking on "Edit" prior to loading the spreadsheets, you can then click on the download content button to bring in the full contents.


    Thanks,
    Sam Lester (MSFT)

SamLester's avatar
SamLester
Microsoft Employee
10 years ago

You can get the contents of the file (as opposed to the metadata) by editing the data source during import. In the query editor window, there will be a column labeled Content, along with an icon that appears to be two down arrows. Click on the icon and you'll add the actual content as opposed to the metadata.

 

 

 

The process is similar when you "Get Data" from a Windows folder containing spreadsheets. By clicking on "Edit" prior to loading the spreadsheets, you can then click on the download content button to bring in the full contents.


Thanks,
Sam Lester (MSFT)