Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
swise001
Continued Contributor
Continued Contributor

Issue connecting to CSV file saved in Onedrive for Business

I've tested this process in the past and it worked fine.  However, recently I've been getting this error returned and I can't pinpoint the reason. 

 

I have a CSV file saved in my files location for Onedrive for Business

I open it in the Excel app and click "Copy Path"

swise001_0-1598970947723.png

In Power BI I use the "Web" connector and remove the "?web=1" from the string: 

swise001_1-1598970998294.png

 

At this point I would expect to get an authentication screen screen similar to this: 

swise001_2-1598971033532.png

 

but instead I get this - every time.

swise001_3-1598971057573.png

 

Any ideas why this error shows up instead of the 'authentication prompt'?

 

 

1 ACCEPTED SOLUTION
swise001
Continued Contributor
Continued Contributor

Solved

The issue was related to global permissions in the Power BI Desktop file.


In my case - I had previously tried to connect to a file in my OneDrive folder for Buisness - Shared with me.

This saved a connection to this file - which generated the error.

Prior to this I had also connected to files on my OneDrive for Business - so I also had another global persmission for this "Onedrive" connection path.

By clearing permissions on both connection routes: I was able to request that the authentication screen be populated when I tried to connect.

It appears that the previous connection stored in Global Permissions (which generated that error) was being used. Extraction - the issue has been fixed.

View solution in original post

2 REPLIES 2
swise001
Continued Contributor
Continued Contributor

Solved

The issue was related to global permissions in the Power BI Desktop file.


In my case - I had previously tried to connect to a file in my OneDrive folder for Buisness - Shared with me.

This saved a connection to this file - which generated the error.

Prior to this I had also connected to files on my OneDrive for Business - so I also had another global persmission for this "Onedrive" connection path.

By clearing permissions on both connection routes: I was able to request that the authentication screen be populated when I tried to connect.

It appears that the previous connection stored in Global Permissions (which generated that error) was being used. Extraction - the issue has been fixed.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.