cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Titifeleke Frequent Visitor
Frequent Visitor

Unable to connect to online SharePoint site to get data on power bi site

 

Hello,

 

I signed up for trial version of POWER BI site. I want to connect to excel files on my sharepoint document library. From my Power BI site when click on "GET" it gives me an option to connect to different data sources. when I click on " sharePoint", it gives me a field to write the link for my site. But when I insert the link and click connect, it give me the following error message.

 

 

The URL is not valid or you do not have permission to the site. Please check the URL and make sure you have permissions ..."

 

I am one of the site collection administrator on the site and have full control permiision. I can see the content of the site from POWER BI desktop, that might show this not a permission issue. And there is no error on the URL of the site.

 

Please I need help, thanks in advance.

 

3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: Unable to connect to online SharePoint site to get data on power bi site

Hi @Titifeleke,

 

In your scenario, please try the options below:

 

1. Verify the typed SharePoint site URL is correct. You can sign in the SharePoint online and copy the site URL.

2. Use Fiddler to trace the HTTP traffic.

3. Check if another user who has permission to access this site can connect to this SharePoint site.

4. Create a new SharePoint site and check if can connect to this new site.

 

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.
Titifeleke Frequent Visitor
Frequent Visitor

Re: Unable to connect to online SharePoint site to get data on power bi site

I think Power BI site can take as a data source only those sharepoint sites which exist in the office 365 which hosts

the power BI site. Because when I insert the link for a sharepoint site which exist in the office 365 which hosts the power

BI site I can connect without any problem. But I want to connect to another sharepoint  online site which  

doesn't exist in the office 365 which hosts the power BI site or a site with different domain. is this possible?

 Thnaks a lot

Moderator v-qiuyu-msft
Moderator

Re: Unable to connect to online SharePoint site to get data on power bi site

Hi @Titifeleke,

 

Based on my test, we are not able to connect to the SharePoint online site which is in a different domain from current Office 365. You can check available site in your Power BI Service without entering any URL, click Connect directly.

 

q3.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.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 143 members 1,809 guests
Please welcome our newest community members: