cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
biagiocaldararo
Regular Visitor

Power BI connection with Sharepoint

Hi everyone, I need to connect Power BI to Sharepoint List but to do so I encountered some issues.

The connection is estabilished but I'm unable to visualize data, in this case Sharepoint Lists.

I also configured a gateway with the correct data source and it seems to work correctly.

I'm using Sharepoint 2013 site with SQL Server 2012.

Here is my problem, any suggestions?

 

6 REPLIES 6
Greg_Deckler
Super User
Super User

Can you post the format of the URL you are using?


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Sure, i use an url with the IP address like this..

http://167.45.178.333/site/anotherworld

Hi @biagiocaldararo,

 

It seems you connected to on-premise SharePoint site to retrieve SharePoint lists data used SharePoint List data source type in Power BI desktop, but there was no available SharePoint lists displayed, right?

 

Based on my test, when we use SharePoint List data source and type the site URL, then it will display the SharePoint list if we have permission to read.  

 

q4.PNGq5.PNG

 

In your scenario, please type the SharePoint list URL in the browser to check if you have permission to view the SharePoint lists under this site. Also please check which Power BI Desktop version in your environment, please update it to the latest if possible.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your answer @v-qiuyu-msft

As the owner of the site I've got the permission to view the SP lists and I'm pretty sure I'm using the latest version of Power BI.

Furthermore, recently I'm working with OData Feed and it seems to work properly.

 

Biagio Caldararo

Hi @biagiocaldararo,

 

It seems the SharePoint is on-premise, can you verify you use SharePoint List data source?

 

q5.PNG

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi everyone, I need to connect Power BI to Sharepoint List but to do so I encountered some issues.

The connection is estabilished but I'm unable to visualize data, in this case Sharepoint Lists.

I also configured a gateway with the correct data source and it seems to work correctly.

I'm using Sharepoint 2013 site with SQL Server 2012.

Here is my problem

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!