Forum Discussion
SharePoint Online list schedule refresh
Hello,
It seem that I cannot scedule a dataset refresh to get fresh data from a SharePoint Online list. The reason seem to be the missing authentication option (Microsoft Account) for the dataset, you may see print screns below from Power BI desktop and the Power BI dataset settings. Am I doing something wrong here?
Power BI Desktop
Power BI portal
5 Replies
Hi Anonymous ,
Based on my test, it could work on my side:
Could you have tried to clear your permission and try to get data form your SharePoint Online list in Power BI Desktop again?
Regards,
Daniel He
Dear v-danhe-msft (Daniel),
Yes I have done this but no chanse I am completely missing the Windows account authentication option in the Power BI portal, I can only see it in the Power BI desktop. I have the most up to date Power BI version. Could it be that there is some seeting needed in the Power BI Admin console?
In your print scereen you show the privacy level not the authentication method. The authentication method seem to be Anonymous and this will not work.
Thanks for helping me out.
Hi Anonymous ,
No, the authentication method is OAuth2:
I suggest you to try again and check with your SharePoint list url.
Regards,
Daniel He
