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