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

Excel File source located on Sharepoint: Access issue

Dear All,

 

I need your support.

I have created my Data Model with POWER BI Desktop on my local drive and currently porting it in a sharepoint.

>> I trying to update the 'Data Source Settings' from my local FactTables Excel files to the Sharepoint FactTables Excel Files

Capture_PBI.PNG

a) I click on change source

b) Copy the link of the Excel FactTable located on Sharepoint

As I complete this update this replaces the local patch (on my C: drive to the Sharepoint location)

Capture_PBI2.PNG

So far so good, I finish the job, then I want to apply the changes and run the refresh and I get the following error:

Capture_PBI3.PNG

I then try the Windows one with the 'Use my current credentials' As I'm already signed in on my PBI Desktop.

>> But same error message:

Capture_PBI4.PNG

As I use the Company Global Office 365 account I then and last try the 'Organizational account' option:

Capture_PBI5.PNG

>> my first surprise is to see 'Your aren't signed in' were I am on the Descktop app. But OK, I click on 'sign in'

A default.aspx window pops up asking me to select the account, my account is already pre-displayed, I select it but nothing happens,

Capture_PBI6.PNG

the window does not close and when I return the the desktop window I get again an error message:

Capture_PBI7.PNG

 

I'm stuck!!

I'm owner of the sharepoint were the excel files are located, the sharepoint is located on the same company Office 365 environment. What is preventing me to do this very basic operation?

2 REPLIES 2
Super User
Super User

Re: Excel File source located on Sharepoint: Access issue

Have you tried selecting a higher level in the "Select Which Level to apply these settings to"?


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Community Support Team
Community Support Team

Re: Excel File source located on Sharepoint: Access issue

Hi @10124564,

Could you have tried clear the permission and try to get data again with your company Global Office 365 account?

https://www.c-sharpcorner.com/article/edit-or-remove-permission-from-existing-data-source-connection...

 

Regards,

Daniel He

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