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).
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
27 |
User | Count |
---|---|
91 | |
50 | |
44 | |
40 | |
35 |