Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get data in Power BI Desktop from a personal SharePoint List (aka Microsoft Lists)

Even though there is a Power BI integration option in Microsoft Lists, its functionality is limited, and I often experience issues. Therefore, I was looking for a way to import the data from a List in Power BI Desktop. This is simple for Lists that are connected to a Collaboration Site on SharePoint as you just need the SharePoint Site Web Address.


However, Lists that are saved to "My Lists" in Microsoft Lists do not appear in any collaboration sites on SharePoint and it is a bit tricky to get data in Power BI Desktop from these personal Lists. However, it can be done and below is a step-by-step guide for how to do this: 


1. Go to the personal List in question and click the "List settings" in the top right corner



2. Mark the first part of the Web Address and copy it



3. Go to Power BI Desktop, click "Get Data", select "Other", select "SharePoint List", and click "Connect"



4. Paste the first part of the Web Address from step 2 and click "OK"



5. Select the title of the List in question and click either "Load" or "Transform Data"



Now you can create Power BI reports based on the data SharePoint List and this does not require a Data Gateway to enable scheduled data refresh in the Power BI Service. 


Hope this helps other people in the same situation as me!

Community Support
Community Support

Hi @Anonymous ,


Thanks for your sharing !


Best Regards,

Neeko Tang

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors