Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@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,
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).
@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,
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).
User | Count |
---|---|
72 | |
67 | |
38 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |