Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi ,  Anonymous 

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))

 

 

 

2)Then publish the report to service 

 

 

 

Best Regards,
Community Support Team _ Eason