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

PowerBI Sharepoint Data Issues

Hi Everyone, 

 

I have a series of list hosted in Sharepoint that im connected to in PowerBi. Im having a couple of issues with one of the lists:

 

Firstly, I have a date column in the sharepoint list, when this is connected to powerBi (with no filters etc) the dates appear one day before the dates that were entered in the sharepoint list. For example, 12/04/2017 in Sharepoint becomes 11/04/2017 in PowerBI.

 

Secondly. Not all of the data is imported. PowerBi seems to only display 4 sets of data for each day. I have attached a screenshot to explain this better. 

PowerBi Issues.png

 

Has anyone experienced similar issues to this? Or know how to fix this, im completely lost!

 

Thanks in advance for all of your help. 

 

Pete

1 REPLY 1
fivebyfive Occasional Visitor
Occasional Visitor

Re: PowerBI Sharepoint Data Issues

Hi Pete - on your dates issue, the regional settings on your developer workstation could affect the interpretation and use of dates and their related functions.  What time zone is your workstation in and is the sharepoint list hosted in a region different from where you are physically?

 

For the SharePoint connector, I've experienced problems with the SQL 2016 SSIS connector for SharePoint lists (they may be related components).  Unfortunately I was not able to get any help with this from the community nor Microsoft and we ended up building a custom connector for the client.  Are you fixed on using SharePoint as a source?

 

Sean

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors