Forum Discussion
Solved
Excel DataSource
I created a powerBI report using an Excel file that is located in a SharePoint online folder. I've then published to PowerBI service. I'm unable to refresh this dataset within the service. I'm not...
I tried this several time earlier, but as you listed it I thought I'd try one more time. This is the solution, but I kept getting a Status Code 400 error. In SharePoint on-line I was clicking the elipse and using the copy link option.
To troubleshoot the 400 error I pasted the link in Notepad and then cleaned it up. The copied url added an extra :x/:r . After removing these items I then redeployed and was able to get the credentials to work. I was given the OAuth option and Orginizational Level.
I've since created a flow to process the dataset anytime the spreadsheet is updated.
I appreciate everyone that replied to my issue.
