Site Collection Settings - Site Usage - Access data within PowerBI

%3CLINGO-SUB%20id%3D%22lingo-sub-1101310%22%20slang%3D%22en-US%22%3ESite%20Collection%20Settings%20-%20Site%20Usage%20-%20Access%20data%20within%20PowerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101310%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EUse%20case%3C%2FSTRONG%3E%20%26gt%3B%20the%20Site%20usage%20option%20returns%20very%20useful%20analytics%20about%20Visits%2C%20Unique%20Viewers%20%26amp%3B%20other%20stats%20for%20the%20site%20in%20general%20%26amp%3B%20particular%20pages.%20With%20the%20Site%20usage%20data%20we%20could%20get%20an%20overview%20of%20how%20well%20the%20user%20adoption%20is%20in%20general%20and%20which%20pages%2Finfo%20is%20consulted%20often%2Fregular%2Fseldom%2Fnot.%20Unfortunately%20there%20a%20few%20conditions%20%26amp%3B%20drawbacks%3A%3C%2FP%3E%3CUL%3E%3CLI%3EOnly%20Site%20Collection%20owners%20can%20access%20the%20Site%20usage%20option%20%26amp%3B%20dat%3C%2FLI%3E%3CLI%3E%3CSPAN%3EOur%20current%20intranet%20(built%20on%20SP-O365)%20consists%20of%20multiple%20site%20collections%20and%20many%20pages%20%26gt%3B%20which%20impedes%20that%20we%20have%20to%20click%20%26amp%3B%20collect%20data%20from%20a%20dozen%20different%20places%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3EQuestions%3A%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3EIs%20it%20possible%20to%20access%20the%20data%20shown%20on%20the%20Site%20Usage%20page%20from%20within%20Power%20BI%3F%3C%2FLI%3E%3CLI%3EIf%20so%2C%20how%20(%3CSPAN%3Esource%2FURL%2F%E2%80%A6%3C%2FSPAN%3E)%20can%20we%20then%20connect%20to%20that%20data%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20188px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164722i7D6D22C1BA8C3EED%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Settings-SiteUsage.png%22%20title%3D%22Settings-SiteUsage.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164724iD7980623B6D77C98%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Settings-SiteUsage-SiteVisits.png%22%20title%3D%22Settings-SiteUsage-SiteVisits.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164723iDB79E03B197F2E66%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Settings-SiteUsage-UniqueViewers.png%22%20title%3D%22Settings-SiteUsage-UniqueViewers.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1101310%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Contributor

Use case > the Site usage option returns very useful analytics about Visits, Unique Viewers & other stats for the site in general & particular pages. With the Site usage data we could get an overview of how well the user adoption is in general and which pages/info is consulted often/regular/seldom/not. Unfortunately there a few conditions & drawbacks:

  • Only Site Collection owners can access the Site usage option & dat
  • Our current intranet (built on SP-O365) consists of multiple site collections and many pages > which impedes that we have to click & collect data from a dozen different places

Questions:

  1. Is it possible to access the data shown on the Site Usage page from within Power BI?
  2. If so, how (source/URL/…) can we then connect to that data?

 

Settings-SiteUsage.png Settings-SiteUsage-SiteVisits.pngSettings-SiteUsage-UniqueViewers.png

0 Replies
www.000webhost.com