cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mardin
Advisor

Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to the site"

We have previously "Published" our .PBIX files to the Service by choosing the "Get Data" option in Power BI Online, the selected Sharepoint and typed the Site URL and selecting the .PBIX file from the Sharepoint folder.

 

The reason is we want to "Publish" our .PBIX files to multiple Workspaces and leverage the "OneDrive Refresh" option, so that we only edit the original .PBIX file in the Sharepoint site and all changes are then automatically "published" to the linked Power BI Workspaces.

 

Recently we are seeing an error when selecting "Sharepoint" from the "Get Data" menu. Any ideas why this is happening?

Untitled.png

10 REPLIES 10
Community Support Team
Community Support Team

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

Hi @Mardin ,

 

Please use the URL below, then click on " /sites/<sitename>/Shared Documents " to choose your file .

https://xxxxx.sharepoint.com/sites/<sitename>

 

36.png37.png

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Mardin
Advisor

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

@v-xicaithis is exactly what I do when I get above error. I enter the root link to the sharepoint site, not any sub folders. 

The root link produces above error.

 

Could it be that our Office 365 admins have somehow disabled the connection between Sharepoint and PowerBI?

angger Visitor
Visitor

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

I'm having exactly the same problem in my organization,  in the same conditions. All worked fine till  few days ago a now it doesen't work anymore with the same error message "he URL is not valid .." . I had the same problem with Power BI Desktop but i was able to resolve the issue when connecting sharepoint folder resetting all the credential properties, and now i can connect my sharepoint site with power bi desktop,  but with the PBI on-line version i'm unable to resolve the issue.   

Mardin
Advisor

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

@v-xicaican you please advise? The issue is still there, and we don't know how to proceed. Is it a bug on server side?

Anonymous
Not applicable

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

@v-xicai Hello, am too having the same issue. Do you have any advice for this? Thanks

oddsverre Visitor
Visitor

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

We experience the same - any news on this issue?

rjhale Regular Visitor
Regular Visitor

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

I have a case open with Microsoft regarding this issue, and so far we've made next to no progress in the month this problem has been occurring.  It's frustrating to see a production feature be broken for over a month even with a Premiere ticket in with MS.  I'll post back here if we ever figure this out.

 

Anyone else have an update on this one? 

adpeters Visitor
Visitor

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

  1. Go to root site of tenant (https://tenant.sharepoint.com)
  2. Go to Site Settings
  3. Go to Site Permissions
  4. Click on "Permission Levels" in the ribbon
  5. Create new permission level that includes "Open" and "Use Remote Interfaces" 
  6. Give users access to the root site using that custom permission level 

 

This resolved this for a few people 

DP86 Frequent Visitor
Frequent Visitor

Re: Service: Get Data -> Sharepoint | "The URL is not valid or you do not have permission to

Amy @v-xicai , I am also having this exact issue, and desparately needing to learn a solution. Your support would be highly appreciated.

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.

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.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 423 members 3,430 guests
Please welcome our newest community members: