Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

power bi changes date from source data

When I get data from SharePoint, or refresh the data, Power BI changes the dates that are downloaded from SharePoint.   For instance I have a column called "Period Start" which is always the first ...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

By my tests with your data sample, I cannot reproduce your scenario.

 

I created the SharePoint List with your data sample and get data with SharePoint list connector in Power BI, everything works as expected.

 

 

Please check the timezone for your SharePoint and your Power BI.

 

Best  Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Cherry

 

I have checked both SharePoint and Power BI settings and they are correct. So I am a bit stuck, without resort to a power query solution. 

 

Cheers

Steve