So I am pretty much self taught on SharePoint and have just recently built a Rest API off one of my lists. Now say I wanted to ingest that API into a program like power BI? is that possible? I guess my question is what would be my next steps for exporting/ingesting the data.
closed as unclear what you're asking by Robert Lindgren, Ganesh Sanap, MHeld, Gaurravs, Aakash Maurya Apr 18 at 6:50
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
- Launch Power BI Desktop
- Click Get Data from the ribbon
- Click OData Feed.
- Enter a URL to a SharePoint web service. This one retrieves all Touring bikes. This example assumes a list named “Bikes for Power BI” Example: https://yourDomain.sharepoint.com/sites/yourSite/_api/Lists/GetByTitle('Bikes for Power BI')/Items?$filter=category eq ' Touring'
- Click OK.
- Find and checkmark your SharePoint list.
- Review your data and click Edit. (SharePoint adds a number of hidden/internal columns that you will probably want to exclude.)
- Optional: In the Query Settings area, click in the Name box and enter a new name for the imported data.
- Select all of the columns that you do not need and click Remove Columns. Or, select the columns you want to keep, click the dropdown under Remove Columns, and click Remove Other Columns. For the class’s example list, keep the bikeID, color, category, size and price columns.
- Click Close & Apply.
- Create your visuals!