Hi All,
One of our client provide access to there SharePoint online site to me.
I want to create a Dashboard using Power Query which will import/consolidate etc.. data from client's SharePoint location and show the live summary of the reports.
This template will be used by both the organizations. Now the issue is that as soon as I am trying to import data from client SharePoint site, Power query automatically login to my organization and I am getting error like Access forbidden.
For temporary solution I have sync client SharePoint folder with my local desktop folder but the issue is that only I can use that Template due to link to my local desktop sync file.
Can anybody suggest me the better approach in this case ?
Regards,
Rajender
One of our client provide access to there SharePoint online site to me.
I want to create a Dashboard using Power Query which will import/consolidate etc.. data from client's SharePoint location and show the live summary of the reports.
This template will be used by both the organizations. Now the issue is that as soon as I am trying to import data from client SharePoint site, Power query automatically login to my organization and I am getting error like Access forbidden.
For temporary solution I have sync client SharePoint folder with my local desktop folder but the issue is that only I can use that Template due to link to my local desktop sync file.
Can anybody suggest me the better approach in this case ?
Regards,
Rajender
