PowerBI: How to import an Excel file located in a SharePoint

I share here a recent learning about how to load data from an Excel file located in a SharePoint into PowerBI.

How to get Url from OneDrive/ SharePoint file sync location? (improved)

In a previous post, I have described how to get the url from a sync onedrive file location, but the solution wasn't perfect and needed user intervention to correct the path in case a subfolder was sync'ed (instead of the root level of the document library).

SharePoint links incl. Stream automatically redirected to Microsoft Edge browser

Because I don't use Edge as default browser, Microsoft keeps bothering me, asking me to open Microsoft Edge when I click on e.g. SharePoint links. I share here my solution to avoid it.

How to get the file link from a SharePoint/OneDrive Sync location

This is a technical post highlighting some implementation part in the NWS PowerTool.

This explains how to get the URL to a file in a SharePoint Online or OneDrive from its local synced location.

Sharing nice links from SharePoint/ OneDrive Sync location

Using the NWS PowerTool, you can conveniently share nice links to files located in your OneDrive or a SharePoint Online directly from the File Explorer Sync location.

The local file location is automatically translated to the URL cloud location.

With nice links I mean that you can choose if you want to display the link in a clickable-breadcrumb format and also that if the file is located in a Teams SharePoint you will get a link to the related Team.

Example:  Knowledge Brokers Team: General > Knowledge Broker Toolkit > Overall Introduction_Knowledge Brokers.pptx 
This page is currently a draft/ WIP. Reach out to me if you want it to be finished soon.