Forum Discussion

greenawayr's avatar
greenawayr
Helper I
8 years ago

SharePoint Online List Data Source Connection error.

Hi,   I have report server 2016 and Power BI Desktop (Oct 2017) and I'm trying to create a data source that connects to a SharePoint list. It seems like it should be the simplest thing, we've alrea...
Stachu's avatar
Stachu
Community Champion
8 years ago

When I connect to SharePoint I get following syntax being generated:

let
    Source = SharePoint.Tables("https://domain/site/subsite", [ApiVersion = 15])
in
    Source

EDIT - I just noticed that you're askign about the SSRS connectiity, not PowerBI, I'm afraid I cannot help with that 

greenawayr's avatar
greenawayr
Helper I
8 years ago

I wasn't quite sure what you meant with that, so here is a screenshot of where I'm at. Just getting an error when testing that connection saying the connection string is not valid.