SharePoint ACS is retiring on April 2, 2026. Check the Microsoft announcement about this. If you or your organization has been using the old AppRegNew.aspx or AppInv.aspx pages to grant apps access to SharePoint, those permissions will stop working after that date. The modern replacement is an Entra ID app registration combined with the Sites.Selected … Read more
When you first get started with Power BI Desktop, it’s common to connect to an Excel file as the data source for your report. In Power BI Desktop, you simply select Excel Workbook, choose a file from your local machine or OneDrive, click Load, and start building your report. Refresh option disabled for semantic model … Read more
SQL Server temporal tables are a powerful feature for tracking how data evolves over time. They automatically maintain historical versions of rows, making them invaluable for: What are temporal tables? A system-versioned temporal table consists of two physical tables: SQL Server manages these tables automatically when system versioning is enabled. However, when you need to … Read more
I was looking for a simple way in Power BI Desktop and Power Query to manually add a row to an existing table using Power Query M. This is not supported through the standard Power Query interface, but is possible by using the Advanced Editor. In this example, I add an extra row to the … Read more
I ran into this question when I wanted to import cost analysis data from Azure into Power BI Desktop using Power Query. Azure Cost Management lets you schedule a daily export of week-to-date or month-to-date cost data and store the files in an Azure Storage account. When you enable this, the export process creates a … Read more