Ted Yu

SharePoint Folder Access

Limit User Access to a Single SharePoint Folder

🔒 How to Grant User Access to Specific Files or Folders in SharePoint When you need to limit a user’s access to only a specific folder or file in SharePoint, you can configure unique permissions o...

Posted by Ted on July 1, 2025

How to Create a SQL Server Login and User with Schema-Level Permissions

Grant Schema Permissions in SQL

How to Create a SQL Server Login and User with Schema-Level Permissions When setting up access for applications or users in SQL Server, a common requirement is to create a login at the server leve...

Posted by Ted on June 23, 2025

Power BI Audit Logs Script

PowerShell Script to Ingest Power BI Logs into Azure SQL

🚀 Automating Power BI Activity Log Ingestion into Azure SQL Database with PowerShell When managing Power BI at scale, monitoring user activities is crucial for governance, security, and usage anal...

Posted by Ted on November 2, 2024

PowerShell Script for Power BI Workspace Scanning and Database Storage

Power BI Scanner to SQL Server

PowerShell Script for Power BI Workspace Scanning and Database Storage The following PowerShell script serves as a robust solution for scanning Power BI workspaces, extracting details about dashbo...

Posted by Ted on December 7, 2023

PowerBI Tenant Settings Retrieval

Using markdown to make a post

PowerShell Script for Power BI Tenant Settings Retrieval The following PowerShell script is designed to retrieve Power BI tenant settings from a specified API endpoint and store the information in...

Posted by Ted on December 6, 2023

PowerBI Gateway DataSource Script

Gateway and DataSource User to CSV

PowerShell Script for Power BI Gateway and DataSource User Information PowerShell, a robust scripting language, empowers users to automate tasks efficiently. In this script, we delve into the real...

Posted by Ted on December 4, 2023

AzureAD Group Members Info.

AD Group to CSV

Retrieving Azure AD Group and Member Information using PowerShell PowerShell is a powerful scripting language that enables automation and management of Microsoft Azure resources. In this article, ...

Posted by Ted on December 1, 2023

PowerBI Report Size Tracker

Report Size to CSV

Automating Power BI Reporting with PowerShell PowerShell scripting provides a powerful toolset for automating tasks, and when it comes to managing and extracting information from the Power BI serv...

Posted by Ted on November 20, 2023

PowerBI Inventory Management Script

PBI Workspace Summary to SQL Server

Automating Power BI Inventory Management with PowerShell and SQL Server Power BI is a powerful tool for data visualization and business intelligence, allowing users to create interactive reports a...

Posted by Ted on November 16, 2023

Automating Power BI Refresh Performance with PowerShell and SQL Server

PBI Workspace Metadata to SQL Server

Automating Power BI Refresh Performance Data Collection and Analysis with PowerShell and SQL Server Power BI is a powerful business intelligence tool that allows organizations to visualize and ana...

Posted by Ted on November 15, 2023