Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |