Excel DataSource

[jflong11]

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 sure what I'm missing, but I've wasted too much time on something that seemingly should be pretty straightforward.  Any suggestions would be appreciated.

I apologize if this has been asked already.  I spent a ton of time on Google and everything seemed focused with PowerBI desktop. 

[sevenhills]

Quick steps for connecting to SharePoint using Pow... - Microsoft Power BI Community

[sevenhills]

Assuming it is sharepoint online, check these and see if it fixes

1. Power BI Service -> Workspace -> Data flow -> right click -> Settings

2. Data source credentials > SharePoint > Edit credentials and see if you can connect 

3. Once you are able to connect, go back to data flow and refresh

[jflong11 · Accepted solution]

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.

[sevenhills]

Yes, copy and paste of the url will cause that error and this approach of copy paste causing error is there for many years. 

Other way I do is 

From SharePoint online, open the file in Excel desktop, and in Excel after the file opened > File (menu) > Info, copy path, paste in notepad, copy the url portion that we need.

Like removing the words "?web=1" at the end

[collinq]

Hi @jflong11 ,

It matters a bit if this is SharePOint online or SharePoint internal.  If it is internal, you will need a gateway setup.  That said, take a look at this article: Get data from Excel workbook files - Power BI | Microsoft Docs