cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBIUser007
Frequent Visitor

Connect to SharePoint List from Power BI Service

Hi all,
Is it possible to connect to a SharePoint List from power Bi service?


I can connect to a list from power BI desktop and publish it to service. But I'm limited by the factor that I can do only 8 scheduled refreshes per day as I use a power BI pro license.


My understanding is that if you connect to SharePoint from power BI service an auto refresh happens every hour. But I could only connect to excel, and csv files maintained in SharePoint from service. Is there a way to connect to a SharePoint list from service?


Thanks in Advance,

1 ACCEPTED SOLUTION

Hi @PBIUser007 ,

 

Maybe I am not fully understanding the problem - but, yes, the Service will update hourly from a SharePoint List as well.  You may need a gateway but if you are online then you are ok.  Yo mention OneDrive.  If you have a document in OneDrive, you can have that refresh every hour as well.  (Up to the 8 that you get with the Pro license.)  These are two separate things - you have a file in OneDrive or you have a SharePoint List - but they can both be updated up to 8 times a day.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

4 REPLIES 4
collinq
Super User
Super User

Hi @PBIUser007 ,

 

You may need to have the gateway setup to reach the SharePoint list if your SharePoint is inside your firewall.  If it is online, there should be no fundamental difference between getting to the csv files in SharePoint versus a list.  Be sure that you are using the right connector - SharePoint Online List or SharePoint List - to connect to a list in SharePoint.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




@collinq thanks for the response. I'm able to connect to a SharePoint list from desktop using SharePoint online connector. But then I need to set up scheduled refreshes to update the data in my report (only 8 refreshes per day as my report is in a shared capacity).

 

I'm looking for an option to see if I can connect to SharePoint list from service so that I can enable one drive refresh (hourly update). Do you think it is possible to connect to a SharePoint list from power BI service?

Thanks in advance,

Hi @PBIUser007 ,

 

Maybe I am not fully understanding the problem - but, yes, the Service will update hourly from a SharePoint List as well.  You may need a gateway but if you are online then you are ok.  Yo mention OneDrive.  If you have a document in OneDrive, you can have that refresh every hour as well.  (Up to the 8 that you get with the Pro license.)  These are two separate things - you have a file in OneDrive or you have a SharePoint List - but they can both be updated up to 8 times a day.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




@collinq Thanks a lot. Earlier my understanding was that a onedrive refresh will happen 24 times even with a pro license. Now I get that it will happen only 8 times if you have a pro license. 

 

Many Thanks!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors