SharePoint import only showing files names list and not contents of each file

[MichaelDrummond]

I have been working with PowerBI desktop and have started working via powerbi.com.

I have been able to configure a folder on my local computer that holds many Excel files exported from a 3rd party system.

Each time an exported XLSX is added to the folder I can open PowerBI desktop and click refresh and the new file data is added to my tables.

I can see that when I publish this to Teams, powerbi.com holds this information and dataset can be set to automatically refresh.

I have tried to configure a SharePoint folder using powerbi.com and via PowerBI desktop.

I was hoping to use the automatic refresh to import the data from any new file (I think it will re-import all files) that gets saved to the SharePoint site folder and display to the Teams site where the PowerBI visualisation is displayed.

When I try to view the contents of the SharePoint folder, PowerBI gives me a list of file names and does not show me the contents of each file.

How can I view the contents of all files in the SharePoint folder?

[BA_Pete]

Hi @MichaelDrummond ,

If you use either the SharePoint Files or the SharePoint Folder connector, you will get a table in Power Query that contains a list of relevant files along with a [Content] column that holds the file contents as binary values. If you click on the yellow word 'Binary' in this column, you will expand the file contents into PQ.

If this isn't the behaviour that you're seeing, can you provide some further detail, such as screenshots etc., of what you're seeing please?

Pete