Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi
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
Thanks, but there is only an offset in the dayligh saving time esle there is no offset.
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
Hi , @Anonymous
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.