using Excel REST APIs sharepoint online in power bi

---

naijacoder wrote:

Hi All,
      I'm a newbie here but need to get up to speed with PowerBI.
I'm trying to visualise Audit Logs( I have setup some logs that writes to excel online) in sharepoint results using Power BI.
I'm sure this should be possible and i try connecting through ths url below:-

http://xxx.sharepoint.com/_vti_bin/ExcelRest.aspx/Audit/Run_a_custom_report_2016-08-20T212904.xslx/Model/Tables('Tablel')?$format=json

 

But can't get it to work and not sure if this is for only Sharepoint on premise and not online after going through this URL

https://msdn.microsoft.com/en-us/library/office/ff394530.aspx

 

Also i did setup a content activity report in my sharepoint online

-Content viewing  doesn't work and returns error sorry something went wrong

-Content vmodification works and outputs an excel online which i'm tying to use

---

naijacoder

Most part of your post is regarding Sharepoint online development, I think a dedicated forum for SP online is a better place for your question. And as per the BOL link, it says,

• The Excel Services REST API applies to SharePoint 2013 and SharePoint 2016 on-premises. For Office 365 Education, Business, and Enterprise accounts, use the Excel REST APIs that are part of the Microsoft Graph endpoint.

So it seems the SP online use different REST APIs.

Regarding Power BI side in your scenario, I suppose you mean Power BI desktop. There's only one SP online list as source, however it is possible to call a REST API sending authentication token in Power Query, which may make your requirement possible.

Check a sample Getting data into Power Query with the twitter search API (how to hack PQ to use OAuth).