I have connected my Sharepoint online data to Power BI desktop using Microsoft Account. (As, Anonymous/windows authentication is not working). Published the report to Power BI service. I am using Data Gateway-Personal mode. On-premise data gateway is not available for now.
Now i want to start schedule referesh Daily. But its giving me following error. Scheduling options are grayed out
I tried all the possible ways to login and edit the credential, its still not working.
If the data sourcein the report is your local file, not the file in the SharePoint online, though you set the schedule refresh for the dataset, it retrieves data from local Excel instead of SharePoint Excel file. If you want to set the schedule refreshto retrieve data from SharePoint Excel, I suggest you to refer to below steps:
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:
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 tohttps://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Community Support Team _ Cherie Chen If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.