Forum Discussion
Schedule Refresh for SharePoint connection not working
Hi,
Thanks for your reply.
I dont have data source on my local machine and not even in excel also. I am directly connecting to the stakeholder's SharePoint site as they have given me the access to their site. I am connecting to the data in Power BI desktop using following steps:
1) Get data->Sharepoint Online List->link of sharepoint site(https://sitename/sites/ES_GTT/)->OK(by signing into Microsoft Account)
Note: while signing in Windows/Anonymous authentication is not working
2) Published the report to Power BI service and then cliking on Schedule referesh.
Please see the screenshot for your reference the way I am connecting to data.Image 1
Image 2
Please help or else suggest any other way to connect to the datasource. As I have to Referesh this data twice in a day and we currently not in a position to have On-Premise Gateway.
Thanks.
Hi Anonymous
I cannot reproduce your issue. Please check if this post could help you.If it is not your case,you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Regards,
Hi Cherie thanks for quick response.
I checked the link which you shared. It is bit useful. But whenever I Click on Edit Credential option I cannot see authenication method as "OAuth2" in power bi service. See below screenshot: 2) I tried using both the options showing above but its giving below error:
I hope u understand it. meanwhile I will Create a Support Ticket also.
Hi Cherie,
is there any solution for this. I haven't received any reply from support ticket also.
Hi Anonymous
I cannot reproduce the same issue.Find an article for your reference.Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
http://www.axioworks.com/2018/02/using-power-bi-with-sharepoint-data-the-ultimate-guide/
Regards,