How To: Import SharePoint libraries into Power BI and create links to the documents

If you have tried to import from SharePoint to power BI you have probably realised you can import Lists and folders but not libraries. In this post, which is based on a video by Ruth Pozuelo Martinez who is a Microsoft MVP we’ll look at the Ruth’s suggested steps for doing the following:

• Export the data from a SharePoint document library into the Power BI desktop
• Create a visualisation that includes the document name and full path to the document document in the SharePoint document library
• Make the full path to the SharePoint document clickable in the Power BI visualisation
• Provide a clickable icon in the Power BI report rather than a long URL in the SharePoint document item

We won’t cover how to publish the data into Power BI online. We’ll cover that in a later blog post. We’ll also cover a shortcut for keeping SharePoint data in Power BI always up to date (rather than 8 times a day using the Power BI gateway)

Read the full article:

How To: Import SharePoint libraries into Power BI and create links to the documents