Forum Discussion
Resolver IPowerBI linked to SharePoint Lists require a Personal Gateway?
Yes Konstantinos, i have this working now.
My problem was i was trying to connect to the exact link for the sharepoint list. In order to correct i had to change this link to the general site address and once connected to the site in PBI Desktop select the sharepoint list from the list of available tables to load the data.
Thanks
Here's a blog post that I've written that describes an alternative use to the personal gateway that uses a 3rd party tool (AxioWorks SQList) to synch the SharePoint lists with normalised SQL Azure tables which then gives you the option of direct query.
Since SQList updates SQL Azure as soon as SharePoint changes are made it is a very nice workaround for Direct Query
Community ChampionNot sure if this is resolved yet. I had similar problems in connecting share point data source to power bi. I could not connet from "Get Data" in PBI.
Instead, I did the following, My Computer >Map Network Drive>Connect to a Web site that you can use to store your document and pictures>Welcome to Add Network Location Wizard>Choose a custom network location>Internet or Network address (Please put the website address only and not the whole path to the list)>Type a name for this network location (Domain Name)> Finish
The share point files get downloaded under Network Location in My Computer. Now go back to PBI>Get Data> Excel>Network Locations>*Desired Excel File*
Everytime the *Desired Excel File* is amended in sharepoint, the update is reflected in the *Desired Excel File* under Network Locations and PBI refreshes it upon refresh in Edit Queries window.