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

Power Bi Service not pulling latest rows from SharePoint list

Hi All,
My Power BI report in Power Bi Service, is not pulling new rows from the source, SharePoint List.
When refreshed, PBI pulls data of the exisitng rows and its latest data, but it not pulling any new rows added to the sharepoint list.

The Strange thing is that, when I download the pbix file, and opened and refreshed in Power BI Desktop, it is pulling the new rows as well.

Could anyone think what is causing Power BI Service to act like this.

6 REPLIES 6
Super User IV
Super User IV

Re: Power Bi Service not pulling latest rows from SharePoint list

Hi there

How are you connecting to the SharePoint list to refresh the data?




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

Proud to be a Super User!






Power BI Blog
Microsoft
Microsoft

Re: Power Bi Service not pulling latest rows from SharePoint list

Hi , @Claru61 

What is the refresh you mean on the service,dataset refresh or just the refresh of the report?

Make sure you have  refreshed  the dataset  as below  rether than part of  data using in report.

85.png

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Claru61
Frequent Visitor

Re: Power Bi Service not pulling latest rows from SharePoint list

Hi

@GilbertQ @v-easonf-msft 

 

I found out what was causing it the issue.

My dates in the report online was somehow wrong, it was showing 1 day less the actual date in SharePoint.

So if you logged a ticket on 30/03 then it power bi online it process as 29/03.

So When I applied the date slicer to the current date, no data was returned because in power online it was yesterdays date.

 

I also found that date/time fields are changed in online the time is 2 hours earlier than the actual time in SharePoint.

But the date and  the date/time is correct in the desktop version.

 

Looks like power bi online is coverting dates into some other time zone date.

Do anyone know how to fix this issue?

 

Many Thanks,

Cleir

Looks like the

Super User IV
Super User IV

Re: Power Bi Service not pulling latest rows from SharePoint list

Hi there

All date/time is based off UTC for the Power BI Servers.

What you would need to do is to adjust your DateTime columns with the offset of what your time zone is.

For example I am in a time zone of UTC +10, so I have to add 10 hours to my datetime columns using the #duration(0,10,0,0)




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

Proud to be a Super User!






Power BI Blog
Claru61
Frequent Visitor

Re: Power Bi Service not pulling latest rows from SharePoint list

Thanks, but there is only an offset in the dayligh saving time esle there is no offset. 

Microsoft
Microsoft

Re: Power Bi Service not pulling latest rows from SharePoint list

Hi ,  @Claru61 

I‘m still a little confused  with your  problem .

Please  follow steps below to check whether there are any differences in the  data   returned from desktop table visual and service table visual.

1)get data from  sharepoint list ,  extract the  "date modifield"  field into a table visual and create a custome  column (UTC +2)

 

 

= Table.AddColumn(Source, "Custom", each DateTimeZone.SwitchZone([Date modified],2))

 

 

55.png

 

2)Then publish the report to service 

 

54.png

 

 

Best Regards,
Community Support Team _ Eason


Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.