Forum Discussion

jflong11's avatar
jflong11
New Member
4 years ago
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...
Need Help
  • jflong11's avatar
    jflong11
    4 years ago

    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.