I have created a Power BI Dashboard using Power BI Designer tool.
This dashboard users queries which pull data from a SharePoint Online environment.
Once the *.pbix file is created using Power BI designer, I uploaded the file to the Power BI site. I had then enabled the Scheduled Refresh option for this DataSet on the Power BI site.
I had specified an oAuth2 connection (as I do not see an Organizational Account option) and stored the credentials and specfied the Schedule for the refresh and saved the settings. The refresh works once after saving, but then subsequently the second time the refresh does not happen and it prompts a message saying credentials are invalid.
When I check the Schedule settings, the credential type has automatically been reset to Anonymous and the oAuth2 settings which I had defined when setting up the schedule does not exist. This means that the concept of scheduling the refresh of these datasets are immaterial, since I have to manually check the schedule evey time and update credentials to refresh the data. This is really painful. Is this a known issue and any solution for this?
