Forum Discussion
OneDrive for Business: Datasource has no credentials
When you author the report in PBI Desktop, use "Web" as the data source instead of One Drive for Business. Then, enter the URL that links directly to the file on your One Drive for Business. It will typically be "URL/documents/File Name of Report.xlsx"
When you store the data source this way in the PBIX file, you can then upload it to the service and the refresh will work, once you enter your credentails on the data source settings as outlined in the previous posts.
Mark
Hi Anonymous - yeah, I have that part working. The PBIX file uses data that its stored in OneDrive and was linked in the way you describe. I have also followed the instructions in previous posts about Settings>Datasets>Data Credentials settings but even when I do this, I still recieve the "your credentials are invalid" error message (eventhough I am already signed in on Office 365 and just about every other system in our office).