A.Connector details and URL to be used:
a.Format of URL for each connector: -
1.SharePoint Folder uses SP Root/Home URL of Site: https://demo.sharepoint.com/teams/BI2
URL can be found if we browse to SharePoint Site's Home page as shown in below screenshot: -
2.SharePoint Online List uses SP Root/Home URL of Site: https://demo.sharepoint.com/teams/BI2
3.SharePoint On prem List uses SP Root/Home URL of Site: https://pXXXXl.XX.XXX.qa/XXXXXX/itXXXX
4.Web Connector for Excel in SPO: https://demo.sharepoint.com/teams/BI2/Shared%20Documents/Financial%20Sample.xlsx
b.Purpose of each connector:
2.Web Connector for excel in SPO:
3.SharePoint Online List:
ii.We use this when we have a list in SharePoint Online and we need to import it in Power BI Desktop.
B.Steps to connect to SPO:
1.SharePoint Folder: https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
1.Please browse to the Excel file in SharePoint Online -> Click on the 3 dots beside the file name -> Open the excel in App as shown in below screenshot: -
2. After the File opens on your local Excel App -> Click on ‘File’ on top left -> Info -> Click on ‘Copy Path’ as shown in below screenshot
3.From the copied link, remove “?web=1” and the resulting link should be like below:-
4.Open Power BI Desktop -> Get Data -> Web -> Paste the link from Step 3
5.Select Authentication as Organizational/Microsoft Account -> Sign In -> Connect -> The file should load.
Author: Srishti Sharma
Reviewer : Mounika Narayana Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.