Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sandeepganju
Regular Visitor

Real Time Data Refresh in power bi from Sharepoint list datasource

Hi,

I need to build up a report in which a user can create/Update Data in sharepoint list and can instantaneously see the data being updated in the Power BI report which has this share point list as a Data Source.

Is this possible ?

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey,

 

as Sharepoint lists are not supported by direct query connection mode.
It's not possible, at least not if the report is published to Power BI service.

You can schedule a refresh for the data source, if you are using Power BI Pro the number of refreshes is limited to 8 times a day, if you are on Power BI Premium you can setup a refresh schedule for up to 48times (every 30min).

 

Hopefully this is providing what you are looking for.

 

Regards,
Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

Hey,

 

as Sharepoint lists are not supported by direct query connection mode.
It's not possible, at least not if the report is published to Power BI service.

You can schedule a refresh for the data source, if you are using Power BI Pro the number of refreshes is limited to 8 times a day, if you are on Power BI Premium you can setup a refresh schedule for up to 48times (every 30min).

 

Hopefully this is providing what you are looking for.

 

Regards,
Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors