how do i build report from multiple workbooks

[Dougers1]

Hi All i am new to power Bi

i want to be able to create a report from multiple excel workbook (monthly data)  - but when i  try i cant see the get data option   how do i do this ?

[christinepayton · Accepted solution]

This is the connector you want, you put the files and SharePoint (assuming you want to schedule refresh) and use the SP folder connector:

https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder

I would recommend installing the PBI Desktop application, you can get it in the Microsoft store.