oAuth2 Credentials for a DataSet connecting to SharePoint Online Automatically Changes to Anonynous

Me too.  My model is from an Excel 2013 workbook with the latest Power Query update (2.24.4064.242).

Hi Smoupre,

I see that you are active and post regurarly on the forum. Kudos!

I have an issue similar to this on one of my datasets. I have created a function that dynamically look up the content of Excel files. Then I use a Sharepoint.Files() connection to a given site, to identify all eligible files (based on filenamepattern). Then I pass the FilePath and FileName as parameters to the function to get the contains of each file. This results in a combined dataset from a dynamic number of files stored on the site. So far so good! It works perfectly in PBI Desktop. But when I publish, I experience the credentials are prompted as 'error' - hence I am not able to schedule refresh in the portal. Neither am I able to manually refresh from the portal.

However, without any changes to the pbix file, I can refresh in Desktop and publish again. Then the changes are reflected on the portal.

Given the above information - is it possible that this is a temporal issue in Power BI? I was performing tests before (from OneDrive for Business, but otherwise equal scenario) - and this was working as expected.

Appreciate if you could take the time to have a look and direct me based on your experience.

Thanks.

/Ronny