Forum Discussion
using Excel REST APIs sharepoint online in power bi
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:-
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
Thanks in Advance nd hope someone can direct me in a good direction
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:-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
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).
1 Reply
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:-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
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).