Power BI & Fabric
Semantic models first, then DAX, SQL warehouses in Fabric, and the small tools that make a data team faster.
22 articles
- FabricFabric Source Atlas: which tables feed your semantic models?Three PowerShell scripts that export every semantic model of your Fabric workspaces and list the SQL tables, views and files each one reads, in Excel and an offline web page.
- Power BIDocumenting Power BI Semantic Model sources Using DAX And AIA DAX query that extracts the Power Query M code of every table in a semantic model, and an AI prompt that turns it into documentation of tables and data sources.
- FabricExploring Power BI Semantic Models with Python in Microsoft FabricA Fabric notebook that uses Semantic Link (sempy) to list a Power BI model's tables and measures, run DAX and SQL queries on it, draw its relationships and check refreshes.
- FabricCreate a Calendar Dimension with SQL in a Fabric WarehouseA SQL query that creates a calendar dimension table in a Fabric Warehouse, one row per day from 1990 to 2050, with date keys, names and month, quarter and year end flags.
- FabricHandling Data Type Conflicts in SQL for Merging TablesA T-SQL script that reads the columns of two tables and generates a UNION ALL query to merge them, converting columns whose data types differ to a common type.
- Power BIAnalyzing Model Dependencies in Power BI with INFO.CALCDEPENDENCY()Five DAX queries using INFO.CALCDEPENDENCY() to see which measures, columns and tables depend on each other in a Power BI model before you change or delete one.
- Power BIOrganize your External toolsHow to tidy the External Tools ribbon in Power BI Desktop by editing the tool files in their folder to remove, rename, reorder or change the icon of each tool.
- Power BIPower BI Scanner API List and document your Power BI tenantA PowerShell script that calls the Power BI Scanner API to export metadata for all workspaces in your tenant to JSON files, with the admin settings to enable first.
- Power BICreate a gradient background for Power BIHow to make a subtle gradient background image for Power BI in Paint.NET, a fix for the rainbow artifacts PowerPoint gradients can show in the Power BI Service.
- Power BIPower BI Sidetools extensions: A Must have!How Power BI Sidetools exports every DAX measure and Power Query to .dax and .m files, so you can version, reuse and search your model code in Visual Studio Code.
- Power BIFilter a Power BI report passing parameters through URLHow to filter a Power BI report from its URL with ?filter=, with ready-to-copy examples for numbers, text, lists of values and several fields, and the main limits.
- Power BILazyDAX: a Power BI File for your presentation, discoveries, or learn DAXA free Power BI file with a clean star schema and DAX measures grouped by function category, ready for demos, testing measures or learning DAX. Download on GitHub.
- Power BIPower BI Visuals List: Which Graphic to choose?A visual overview of the Power BI chart types, tested one by one and kept as a reference for choosing the right chart. The LazyDAX .pbix file is on GitHub.
- Power BIPower BI: Duplicate of Duplicate - The best way to test your reports and measuresA step-by-step way to debug Power BI reports. Duplicate the page, turn the visual into a table, remove filters one by one, test a single row and each measure variable.
- Power BIDAX is case insensitiveDAX string comparisons ignore letter case. Three measures filtering on Vegetable, VEGETABLE and VeGeTaBlE return the same count, shown in the LazyDAX file.
- Power BIPower BI Interview questions: a different way to know your applicantsA list of 16 open interview questions for Power BI candidates, on DAX, data modeling, Power Query, security, Premium and project approach, to see how they think.
- Power BIYour data model first!Before loading data, sketch your Power BI model on paper with your users. List their key terms, group them into dimensions, then shape the data to fit that view.
- Power BIPower BI Create a Calendar table automaticallyA ready-to-paste Power Query M function that generates a calendar table in Power BI from a start and end date, with year, quarter, month, day and week columns.
- Power BIPower BI - Your model mattersWhy one well-designed model beats many report-specific ones, and how to get there by denormalizing source tables and brainstorming with users to find facts and dimensions.
- Power BIPIT Point In TimeHow to show which records were valid on a chosen date in Power BI, with a disconnected calendar slicer and a DAX measure on ValidFrom and ValidTo. Sample .pbix included.
- Power BIPie Chart is bad!Why pie charts are discouraged in data visualization. Two datasets drawn as pie and bar charts show that comparing angles is harder than comparing lengths.
- Power BIPower BI Desktop: Print in the A4 sizeHow to export a Power BI Desktop report page to PDF in A4 portrait format, by setting a custom page size of 794 x 1123 pixels.
