Sharepoint list does now show all data from today

[Johnl]

Hi

I am trying to connect to a sharepoint list, when i look in the query editor it does not seem to display all the data from today, if i set a measure to look at yesterdays data it works fine, if i export the sharepoint list to excel it works fine.

[nandukrishnavs]

Hi @Johnl,

Are you able to view the data in the Data View section?

Regards,

Nandu Krishna

[Johnl]

Hi

No not able to see the data, it is very strange, i think it is something to do with dates, sharepoint is fine can see them all, excell is fine can see them all.

I have worked around the problem by creating a excel file, from sharepoint to excel, excel to Power Bi

Thanks John

[nandukrishnavs]

Hi @Johnl,

You can try OData feed as data source. 

https://<site url>/_vti_bin/listdata.svc

Regards,

Nandu Krishna