cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
naijacoder
Frequent Visitor

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:-

http://xxx.sharepoint.com/_vti_bin/ExcelRest.aspx/Audit/Run_a_custom_report_2016-08-20T212904.xslx/M...

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Eric_Zhang
Microsoft

Re: 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/M...

 

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).

View solution in original post

1 REPLY 1
Microsoft Eric_Zhang
Microsoft

Re: 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/M...

 

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).

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors