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

OneDrive "Web" import is disable

Hello,

in the last few days I'm trying to link a OneDrive Excel file to PowerBI with no success. I've gone through the some microsoft ( such as) officials tutorials as well Curbal's YouTube videos. None of them worked for my case.

 

Something is screeming in my head, that the following message might expose the issue. While following the microsoft tutorial and I get in the Excel file via OneDrive the following message appears:

 

"Links Desabilitados: Não há suporte para links de pastas de trabalho externas e eles foram desabilitados" Which translates to something as:
"Disable Links: There is no support fors links in a extrernal workspace and they were disable"
Screenshot from 2019-01-29 17-15-41.png
 
 
Another message that appears me that might help the case is the one that appears when get the file link, when I open the OneDrive file via Excel (which does not have web=1 on the end as the tutorial shows)... and then copy and paste on the Web option of PowerBI. The message is the following, which is translated:

"It is not possible to stablish a connection

We found an error while trying to connect

Details: "The access to the source is prohibited" "

 

Screenshot from 2019-01-29 17-28-28.png

Please let me know if you need any other information so we can work together

 

Best regards

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: OneDrive "Web" import is disable

@Moya_Novaes,

Please go to  File->Options and Settings->Data Source Settings->Global Permissions in Power BI Desktop, clear permissions for existing onedrive data sources, then re-connect to OneDrive excel following the guide in this article.

Regards,
Lydia

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

View solution in original post

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: OneDrive "Web" import is disable

@Moya_Novaes,

Please go to  File->Options and Settings->Data Source Settings->Global Permissions in Power BI Desktop, clear permissions for existing onedrive data sources, then re-connect to OneDrive excel following the guide in this article.

Regards,
Lydia

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

View solution in original post

Helpful resources

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

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: 335 members 3,387 guests
Please welcome our newest community members: