Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

0
asha

SharePoint Online Lists Refreshing Fails

Submitted by on ‎02-23-2018 04:30 AM

Hi All,

 

I am having a problem withone of reports.

 

My datasources are Sharepoint Online Lists. I need to fetch the data from 27 sites in one report. We are using Odata Feed to connect to lists.

When we tring to refresh the data in Power BI Service I am gettin an error(Note that table is changing, so not always the same one giving me error):

 

Details Type Start End Status Message
Hide
On demand 2/23/2018, 12:06:14 PM 2/23/2018, 12:06:50 PM Failed There was an error when processing the data in the dataset.
Message: The command has been canceled. Table: StaffAvailability.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: c561d089-e515-4c70-9744-455c0b1b2e5e
Request ID: d6afe740-eff3-1f28-723b-b58363424c87
Time: 2018-02-23 12:06:50Z

I tried to use the Get SharePoint List/Library Using SharePoint List Connection to connect to data. For a test I tried 2 sites. It worked fine in the desktop but I am unable to refresh the data in the service (when connecting to a SharePoint Online data source I use same account as to sign in to the Power BI service.

 

Hide
On demand 2/19/2018, 8:37:22 PM 2/19/2018, 8:37:42 PM Failed There was an error when processing the data in the dataset.
Message: The command has been canceled. Table: CompoundProductionQuantities.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 3b041a74-8f76-7091-cf10-e35da300ecaf
Request ID: 79956d16-4b6c-16aa-26fc-70728e54f2a4
Time: 2018-02-19 20:37:42Z

Would anyone be able to help me?

 

Best,

 

Joanna

Status: Delivered
See more ideas labeled with:
5 Comments (5 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎02-26-2018 12:45 AM

Hi @asha,

 

Please create a support ticket. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎02-26-2018 12:46 AM
Status changed to: Delivered
 
asha
Regular Visitor
‎02-26-2018 03:30 AM

Thanks, I created a ticket.

asha
Regular Visitor
‎05-17-2018 02:05 AM

Hi All,

 

If anyone struggle here is the work-around I found for now:

Changing connection string in Advance edititor  from ApiVersion = 15 to ApiVersion = 14 

 

Source = SharePoint.Tables("https://xxx.sharepoint.com/sites/xxx", [ApiVersion = 14),

 

Asha

SoraiaT
Helper I
Helper I
‎04-11-2019 06:56 AM

Hi @asha 

 

Ob the query editor I've tryed to changeconnection string in Advance edititor  from ApiVersion = 15 to ApiVersion = 14 but when aplying the report doesn't work with an error saying it cannot find any line with that key. Have you found this issue?

 

Thanks in advance,

Soraia

Idea Statuses