Pascal Kiefer 🥷

Power BI has launched Tabular Model Definition Language (TMDL) View which is now available in Power BI Desktop. 🎉 With TMDL View, you can script, modify, and manage your semantic models using code offering a powerful alternative to the traditional graphical Model view. This brings precision, efficiency, and flexibility right into your modeling workflow. What makes TMDL View special? - Leverage a rich editor with search & replace, multi-line edits, keyboard shortcuts, and more. - Easily collaborate using TMDL scripts across teams and projects. - Access and edit model objects/properties not exposed in the UI. 💡 And this is just the beginning, future updates will integrate Copilot, enabling advanced capabilities like bulk updates, model translation, and automation of time-intensive modeling tasks. Whether you're building complex enterprise models or streamlining BI solutions, TMDL View empowers you to do more, faster, and smarter. Dive into a new era of semantic modeling with Power BI 🔗 . #PowerBI #TMDL #SemanticModeling #DataModeling #BI #Copilot #DataAnalytics #PowerBIDesktop #MicrosoftPowerBI #DataTools #ProductivityBoost #DataModelers

420

8 Kommentare

🚀 Big Update for Power BI Users – July 2025 🚀 No more switching back and forth between Power BI Desktop and the Service just to test your DAX queries! 🎯 With the new DAX Query View in Power BI Service / Microsoft Fabric, you can now: ✅ Write, run, and test DAX queries directly in the browser ✅ Use Copilot to get DAX code suggestions instantly ✅ Debug, format, and explore your model without opening Desktop ✅ Save time when creating and validating calculations This means faster development, quicker troubleshooting, and more flexibility — especially for those working in collaborative, cloud-based environments. 💡 This is part of the July 2025 Power BI & Fabric update, and it’s a game-changer for developers and analysts who live in DAX every day. #PowerBI #MicrosoftFabric #DAX #DataAnalytics #PowerBIUpdate #MicrosoftPowerBI

389

12 Kommentare

𝗪𝗮𝗻𝘁 𝘆𝗼𝘂𝗿 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗿𝗲𝗽𝗼𝗿𝘁𝘀 𝘁𝗼 𝗳𝗲𝗲𝗹 𝗹𝗶𝗸𝗲 𝗿𝗲𝗮𝗹 𝘄𝗲𝗯 𝗮𝗽𝗽𝘀? It's more achievable than you think - without custom visuals, SVGs, or external tools. 👇 Here's a modern web app layout built entirely with native Power BI visuals. Showcasing a modern navigation bar. 𝗪𝗵𝗮𝘁 𝗺𝗮𝗸𝗲𝘀 𝗶𝘁 𝘄𝗼𝗿𝗸? • 𝗨𝗜 𝗰𝗹𝗮𝗿𝗶𝘁𝘆 – Simple navigation, iconography, and soft cards guide attention • 𝗨𝗫 𝗰𝗼𝗻𝘀𝗶𝘀𝘁𝗲𝗻𝗰𝘆 – Alignment, spacing, and structure are predictable and easy to follow • 𝗩𝗶𝘀𝘂𝗮𝗹 𝗵𝗶𝗲𝗿𝗮𝗿𝗰𝗵𝘆 – Key metrics pop, details follow • 𝗣𝗿𝗼𝗴𝗿𝗲𝘀𝘀𝗶𝘃𝗲 𝗱𝗶𝘀𝗰𝗹𝗼𝘀𝘂𝗿𝗲 – Tabs and toggles reveal more only when needed • 𝗔𝗳𝗳𝗼𝗿𝗱𝗮𝗻𝗰𝗲 & 𝗳𝗲𝗲𝗱𝗯𝗮𝗰𝗸 – Buttons and dropdowns look and feel like they should • 𝗨𝘀𝗲 𝗼𝗳 𝗰𝗼𝗹𝗼𝗿 – Color signals meaning (e.g., red for drop, green for growth), not decoration 𝗪𝗵𝘆 𝘀𝗵𝗼𝘂𝗹𝗱 𝘆𝗼𝘂 𝗰𝗮𝗿𝗲? Because people use what feels familiar. 𝙄𝙛 𝙮𝙤𝙪𝙧 𝙧𝙚𝙥𝙤𝙧𝙩𝙨 𝙛𝙚𝙚𝙡 𝙡𝙞𝙠𝙚 𝙩𝙝𝙚 𝙩𝙤𝙤𝙡𝙨 𝙮𝙤𝙪𝙧 𝙪𝙨𝙚𝙧𝙨 𝙖𝙡𝙧𝙚𝙖𝙙𝙮 𝙠𝙣𝙤𝙬, 𝙖𝙙𝙤𝙥𝙩𝙞𝙤𝙣 𝙗𝙚𝙘𝙤𝙢𝙚𝙨 𝙛𝙧𝙞𝙘𝙩𝙞𝙤𝙣𝙡𝙚𝙨𝙨. And with a bit of layout trickery and attention to UX laws (like Hick’s Law, Fitts's Law, and the Law of Proximity), you can build this right now inside Power BI. No add-ons. Just native visuals. #PowerBI #UIUX #DataViz

248

30 Kommentare

Hi. After 2 years - coming back with the variation of a line chart with centered variance label 🟢 🔴 Notes: 🟦 This time built using standard DAX (non-visual calculation approach). This time it's based on a single-select slicer ('border' period) 🟦 Base: Chart displays last 13 months on x-axis (having 13th month back allows for showing value for prior year period) 🟦Addition 1: Higlighting first and last data point (top chart). Requires a single additional measure to bring both markers (with values) 🟦Addition 2: Adding Top ceiling max line (horizontal) and two error bars (for error bars - no additional measure required - just based on what we already have). - Middle and bottom chart. Requires: 1) One base/core measure (in thata case - sum of impressions) 2) Rolling 12 month Sum (monthly sum of 12 month period) 3) Last 13 month period display _______________________________________________________ This abovementioned metrics can be created also using a single measure or two, depending on how much we want to split it Then additionals: 4) Data points (first and last) 5) Max Value (top ceiling) - horizontal line 6) Centered data point with variance label included 🟦I've used the basic approach a few times in the daily projects (last 13 month instead of last 12 months + first/last data point + variance as a separate card) 🟦 Variance "bridge" would require two additional measures. Never used that so far in the project, but could be a nice visual presentation. 🟦Link to historical post: https://lnkd.in/eUH7Rrsd All best 🖐 #TheDataVisForge #analytics #microsoft #data #powerbi #datavisualization #dashboard #visualization #UX #UI

296

12 Kommentare

We can break down Power BI models into the report layer and the semantic model layer. We can then continue to divide these layers into the smaller components within them. Parsing our models not only technically explains how they work, but it also makes it easier to explain the intricacies of Power BI to a wider business end user audience. The term "Semantic model" in the Power BI service refers to what it previously called "Datasets" until last year. When we publish Power BI models, it creates a semantic model to store the data connections, the transformed data in Power Query, the model connections between the loaded data, and the DAX calculations. Additionally, when we publish Power BI models, it also creates a report layer storing the report pages with the data visualizations and other visual elements on them (plus other functionalities within this layer). The data in the visuals and report pages comes from the semantic model. We can also use the same semantic models in other Power BI Reports and also in other applications like paginated reports. #PowerBI #DAX #DataAnalytics

71

5 Kommentare

New Blog Post! Continuing with #DAXUDF, I know all the rage is with model-independent functions in daxlib.org (which is great), but what about model-dependant functions? Like calculation groups, even when they have dependencies on the model, they are essentially the same function so it's a pitty we need to copy and paste around and fix manually those dependencies. Like I did several times for calc groups, I show how to *industrialize* functions that have model dependencies with a Tabular Editor #CSharp Script , and do so in a way that can then be used by the previous macro that generates measures based on the function adding all the necessary properties (name, expression, formatstring, displayfolder and table). Also I know the new Calendars are the new hot topic, but for now I decided to have 4 classic Standard Time Intel calculations from Daxpatterns.com into functions Anyway, here's the article with links to the scripts! I hope you like it https://lnkd.in/dGiWRsM8 As a teaser, just look at this beautiful video of what can you do:

73

11 Kommentare

Outgrown Excel but need a fast planning solution? Meet the #PowerON Quick Planning App—planning built into #PowerBI in hours, not months. Create apps with security, approvals, versioning, and actuals, all within your Power BI workspace—no new tools or data silos. Plus, get instant insights with AI. Forecasts, scenarios, and explanations in plain language. Key benefits: - Fast deployment with best practices - Native Power BI integration - AI-driven analysis without exports See it in action! 👀 Watch our on-demand webinar to learn more: https://bit.ly/45wxRY0 #FinancialPlanning #Analytics

37

📌Power BI Alerts Stay Ahead of the Data Did you know you can set up data-driven alerts in Power BI Service to get instant notifications when KPIs cross defined thresholds? ➡️ No more manual monitoring ➡️ Real-time updates via email & Power BI Service ➡️ Seamless integration with Power Automate for automated workflows This means you can ➡️ React faster to business-critical changes ➡️ Save time with automated monitoring ➡️ Enable smarter, proactive decisions Use alerts only on key KPIs to avoid notification fatigue and review them regularly for relevance. Start using Power BI Alerts today and make your dashboards truly proactive! #PowerBI #DataAnalytics #Automation #BusinessIntelligence

117

2 Kommentare