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 After publishing the … Read more
SQL Server temporal tables are a powerful feature when you need to track how data changes over time. Common use cases include auditing, implementing slowly changing dimensions, or safeguarding data against accidental modifications or deletions. A system-versioned temporal table consists of two physical tables: one that stores the current records and another that stores the … 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. 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 folder per year … Read more