Yeah!! Glad it helped. The headset is a random inexpensive one I got from the IT department, it’s not fancy. I’m traveling this week but I can check the brand when I get back.
Only in SharePoint on-prem - Online wants you to use the Rest API instead. But the connectors work fine for Excel, I'd only use OData if I were trying to get something non-standard. learn.microsoft.com/en-us/sharepoint/dev/general-development/requesting-excel-workbook-data-from-sharepoint-server-using-odata
Hi, your videos are fantastic! I was after more details on the file statistics on file level in Power BI. So how many views and unique views of example pdf, excel files from a specific site?
The usage data isn’t super accessible to us - my understanding is you pretty much have to get it from the activity API, either with PowerShell or another tool that makes API calls, and store it somewhere yourself (the data only goes back a short time, so it takes a while to build the history). You need pretty high permission in M365 to pull that too, something like compliance admin or global admin. 😅
What happens when the site has thousands of files and you want to point to a specific sub folder? Power Bi/Query just loads the whole site, and even if i try to filter to search that sub folder, since there is so much data, it doesnt find it since the filter options shows you so many results (even if you select show more). I tried to do it by using Sharepoint Folder and using Sharepoint.Contents so its easier to navigate, now i have the folders i want to count its files, but i dont see a way to extract all its files like you get with Sharepoint.List
Not sure what you mean, if you know what folder you want to show then you know the path you want to filter on, don't you? You can just type it in as text with equals or contains. It's going to match the folder name in SP, so if you're not sure what the folder name is there you can just go look at it in SP? If you want to combine the file contents and the file metadata, you can do an inner join between the SP Folder and Odata on the filename and path (do this before expanding the file contents so that it folds for speed).
@@bi-ome The problem was that the specific path didnt show on the filter list, since there were too many files. I ended up first filtering to folders to reduce load, then picking any path for the filter, then editing it out and remove everything after "each", replace it with Text.Contains(on defaults uses equal) and using the folder path i needed. The problem is Power Bi/Query wont let you connect to subfolders directly, so it has to load the entire site first, then filter what you want, wich is not optimal, later doing data refreshes makes them take way too much time. Here i have been waiting a couple minutes for the query changes to import into Power Bi.
@@freedomdst Righto, there's a menu option to filter on specific text with contains - it's under the "text filters" submenu when you click the column - you don't have to use the checkbox list :)
@@thanatorninthisen5815 still have to load all the files, but you can filter by any then edit the step for the one you cant find. There was a right click or top menu option for filtering. I would just do sharepoint sites for each area on the company, but they think having 50tb of data on a single site is good.
The library you select will be whatever library you are wanting to use for this. Documents is the default library created for all SharePoint sites, but you could have many others in there if people on your team have created more!
