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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi there,

    did you ever resolve this?  I'm getting the same thing.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi there,

    did you ever resolve this?  I'm getting the same thing.

    • greenawayr's avatar
      greenawayr
      Helper I
      7 years ago

      Nope. Not yet.

       

      A couple of things to consider.

       

      Firstly, it seems PowerBI Report Server doesn't yet support Shared Data Sources. Idea is Under Review here.

       

      Secondly, and I haven't had chance to go down this route yet, is the option of configuring Kerberos.

       

      Not sure how this all fits together as those two points seem to contradict each other, but it might just be mixed terminology or misunderstanding on my part.