Ted Yu

🏠 房屋入住指南

Tenant Welcome Guide

🎉🎉 欢迎入住 🎉🎉 欢迎入住本房屋。入住即表示您已阅读并同意遵守以下规则。 📋 一、基本居住规则 👟 室内鞋室外鞋请放在门口鞋区二楼禁止穿鞋请保持二楼地毯清洁 Dyson 吸尘器专用充电器请勿拔出，每周房东会给充电，如仍没电请联系房东 🌙 夜间安静避免大声聊天、播放音乐或通话 ❌ 禁止事项室内吸烟举办派对或未...

Posted by Ted on March 11, 2026

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