Fabric Notebook : Tips & Shortcuts
Explore Fabric Notebooks: toggle layouts, freeze/lock cells, embed images, text replacement, and more
Power BI
Fabric
Using Streamlit with Microsoft Fabric
Connect to SQL endpoint using pyodbc and pandas
Using FabricRestClient To Make Fabric REST API Calls
Optimize Fabric REST API with FabricRestClient for auto-authentication and efficient session management in notebooks. semantic link sempy
DAX measure Top N ranking with drill down - Ben's Blog
In this short post, we will explore how to create a DAX measure for Top N ranking with drill down. Purpose of this DAX Measure In many business scenarios, understanding the performance of products at different levels of a hierarchy (such as Category, SubCategory, and Product) is crucial. The ‘Top N Ranking with Drill Down’ measure in DAX allows users to dynamically rank products at each level of this hierarchy based on their sales performance. This dynamic capability means that...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2024/01/23/dax-measure-top-n-ranking-with-drill-down/" Read Morespan class="screen-reader-text" Read More/span/a/p
DAX
Power Apps User Defined Functions: Write Code Once And Reuse
With Power Apps user defined functions we can write a formula once and reuse the logic many times throughout an app.
PowerAppsDeveloping a Curriculum for Microsoft Fabric: Cloud-Powered App Development
We delve into a comprehensive curriculum centered around Microsoft Fabric, aimed at empowering your students in cloud-powered app development.
Add LLM Prompts to Reports using Power BI Copilot for Microsoft Fabric
Report developers can add Copilot Prompts that rerun when data is filtered!
Fastest Way To Patch All Gallery Items In Power Apps
The fastest way to patch all items in a Power Apps gallery is to batch the updates using a little-known variation of the patch function.
Microsoft Fabric Career Resources
I posted about the value of certifications for career growth back in 2020, where I essentially said that certifications are a great way to build and validate knowledge and skills, and can help meet…
Power BI implementation planning: BI strategic planning - Power BI
This article helps you to define your business intelligence goals and priorities through strategic planning.
Conduct independent research: The working team performs research into the business context and existing BI solutions or initiatives.
To define an effective BI strategy, the working team must understand the business goals. By understanding the business goals, the working team has the right business context to describe why people use data and BI tools, and comprehension of their desired outcomes
You should identify the existing BI initiatives and solutions with respect to the business processes they support and objectives they address. These solutions help illustrate what business users do today to address their data needs, so that you can assess whether it's effective.
Taken together, research on the business context and existing BI initiatives and solutions describe the current state of BI adoption and implementation. The working team verifies this research in workshops when capturing stakeholder input.
This article uses the term workshops to describe interactive meetings with key stakeholders. The objective of the workshops is to gather input so you can accurately describe and understand the objectives and data needs.
The following diagram depicts the process to identify and inform the right key stakeholders about the BI strategy initiative.
For each functional area, identify two to three candidate key stakeholder representatives.
hen you initially request key stakeholder participation, ensure that you:
Obtain approval from their manager, as appropriate.
Explain the scope of the initiative, and its objectives, timelines, and deliverables.
Describe specifically why they've been asked to participate and what the desired outcomes are.
Outline the necessary time commitment and participation that you need from them.
Communicate clearly and concisely.
key stakeholders who have sufficient knowledge and credibility to represent their business area.
Identifying the right stakeholders is essential in order to run successful workshops and gain an accurate understanding of the business areas in scope.
Often, top-down BI initiatives limit stakeholders to executives and decision makers. While these individuals have a significant role to play (to obtain sufficient executive buy-in and strategic alignment), they aren't necessarily the right stakeholders. In this scenario, you risk defining a strategy isolated from the reality experienced by business users. This misalignment can result in strategies and solutions that don't meet the needs of day-to-day users, and consequentially they aren't used.
big
The working team investigates strategically important BI solutions to understand how the organization currently addresses business data needs. Specifically, the working team identifies who the business users are, how they use the solutions. The working team also documents key data questions or problems that these solutions address, and also potential flaws, opportunities, and inefficiencies.
The working team identifies strategically important KPIs and master data. These KPIs and master data are critical to enabling the business to achieve their business objectives.
Agree on communication values: Encourage all working team members to engage with concise, clear, and consistent communication throughout the initiative.
Business goals.
Business objectives to make progress towards their goals.
Business processes and initiatives to achieve their objectives.
Business data needs to support the processes and initiatives.
BI tools and solutions that people use to address their business data needs.
How people use the tools and solutions, and any challenges that prevent them from using the tools and solutions effectively.
To help identify priorities, the working team conducts two types of assessment: a data culture assessment and a technical assessment.
Extracting Power BI Import mode Job Graph data to a table
Get the job graph for a refresh in a table using a dataflow
Hack Together: The Microsoft Fabric Global AI Hack | Microsoft Fabric Blog | Microsoft Fabric
Are you ready to unleash your creativity and build amazing solutions with Microsoft Fabric and AI? If so, join us for Hack Together: The Microsoft Fabric Global AI Hack, a virtual event where you can learn, experiment, and hack together with the new Copilot and AI features in Microsoft Fabric! What is Hack Together? Hack …
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/hack-together-the-microsoft-fabric-global-ai-hack/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;Hack Together: The Microsoft Fabric Global AI Hack&#8221;</span></a>
𝐄𝐱𝐩𝐥𝐨𝐫𝐢𝐧𝐠 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐒𝐞𝐦𝐚𝐧𝐭𝐢𝐜 𝐌𝐨𝐝𝐞𝐥 𝐃𝐚𝐭𝐚 𝐯𝐢𝐚 𝐒𝐞𝐦𝐏𝐲 𝐏𝐲𝐭𝐡𝐨𝐧 & 𝐭𝐡𝐞 𝐒𝐞𝐦𝐚𝐧𝐭𝐢𝐜 𝐋𝐢𝐧𝐤 𝐢𝐧 𝐅𝐚𝐛𝐫𝐢𝐜 𝐍𝐨𝐭𝐞𝐛𝐨𝐨𝐤𝐬:
✨Semantic Link unlocks the potential to query data from Power BI's semantic models, which are already cleaned and refined into a gold models, using tools such as Pandas and Spark APIs. This will provide a whole of possibilities for Data Scientists and ML applications.
Fabric Features not found in Azure Synapse or Power BI – Data Wrangler
Fabric Features not found in Azure Synapse or Power BI – Data Wrangler The second element in my series on new Fabric Features is Data Wrangler. Data Wrangler is an entirely new feature found inside…
Creative Thinking in Fabric & Power BI -
In podcast #286 we take the time to review an older video of John Cleese giving a talk about the Creative Process in Management. We thought this would be an outstanding conversation to draw parallels [...]
RASON Analytics API: Restful Analytic Solver Object Notation - RASON.com
Data Visualization
OneLake File Explorer: Update via Excel made Easy | Microsoft Fabric Blog | Microsoft Fabric
With the newest version of OneLake file explorer (v1.0.11.0) we bring a few updates to enhance your experience with OneLake. Excel Integration: Editing made Easy&nbsp; With our latest release v1.0.11.0 of file explorer, we are excited to announce that you can now update your files directly using Excel, mirroring the user-friendly experience available in OneDrive. &hellip;
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/onelake-file-explorer-update-via-excel-made-easy/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;OneLake File Explorer: Update via Excel made Easy&#8221;</span></a>
How to enable Copilot in Fabric for Everyone | Microsoft Fabric Blog | Microsoft Fabric
To get Copilot turned on for everyone in your organization, follow these steps: Sign in to Microsoft Fabric using your admin account credentials. Select Fabric settings and then from the menu select Admin portal. Select Tenant settings and scroll down the page to “Copilot and azure Open AI Service(preview)” and turn on Enabled On your &hellip;
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/how-to-enable-copilot-in-fabric-for-everyone-2/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;How to enable Copilot in Fabric for Everyone&#8221;</span></a>
Automate Fabric Data Warehouse Queries and Commands with Data Factory | Microsoft Fabric Blog | Microsoft Fabric
Microsoft Fabric provides a cloud-scale data warehouse to store your analytical data for dashboards and historical reporting. In Fabric Data Factory, there are a number of ways to query data, retrieve data, and execute commands from your warehouse using pipeline activities that can then be easily automated for unattended background execution. I&#8217;ll go left-to-right from &hellip;
<p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/automate-fabric-data-warehouse-queries-and-commands-with-data-factory/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;Automate Fabric Data Warehouse Queries and Commands with Data Factory&#8221;</span></a>
Model explorer with calculation group authoring is now available in Power BI service including Direct Lake semantic models
With the model explorer available for editing data models in the Power BI service these semantic models, both Direct Lake and those in import or DirectQuery, not only get visibility of their semantic model in a tree view but also can create calculation groups!
Copilot in Power BI (preview) is available worldwide
We are excited to announce that the Copilot preview is now available to all customers!, Now everyone can get value from copilot through analyzing data or creating beautiful out of the box reports.
Dynamic subscriptions for Power BI reports (Preview)
We’re excited to announce that dynamic per recipient subscriptions are now available in Preview for Power BI reports! Similar to dynamic subscriptions for paginated reports, you can now distribute a personalized copy of a Power BI report to each recipient of an email subscription.
How to grant individual users access to create Fabric items/workloads - FourMoo | Power BI | Data Analytics
In this blog post I show you how to grant users access to create Fabric items in a Fabric enabled workspace in Power BI.
Mastering DP-500/DP-600 Exam: Troubleshoot DAX Performance with DAX Studio! - Data Mozart
Troubleshooting DAX performance is one of the most challenging, yet most rewarding tasks! Learn how to leverage DAX Studio external tool to quickly understand why your DAX query is slow!
New Fabric certification and Fabric Career Hub | Microsoft Fabric Blog | Microsoft Fabric
Last year was a remarkable one for the Power BI community. We launched Microsoft Fabric, an end-to-end analytics platform that brings together data preparation, data warehousing, data engineering, data science, real-time analytics, and business intelligence in one unified SaaS foundation with one copy of data stored in OneLake. We also launched Power BI Copilot, making it easier to find insights and build reports using natural language. And our community of over 2 million members continued to engage on our forums, post ideas, join user groups, helping one another in their data journeys.
Prepare your data for a semantic model – Tabular Editor Blog
Copilot in Fabric (preview) is available worldwide  | Microsoft Fabric Blog | Microsoft Fabric
During November 2023, we unveiled the public preview of Copilot in Microsoft Fabric. This preview includes Copilot for Power BI, Data Factory and Data Science & Data Engineering. Since then, we have been gradually rolling this feature out and today, we are excited to announce that our Copilot preview is now available to all customers! With the Copilot preview, Microsoft … Continue reading “Copilot in Fabric (preview) is available worldwide “
Introducing Approvals kit
<p>Streamline your organization&#8217;s approval processes with the Approvals Kit &#8211; a no-code, ready-made kit built on top of Power Platform components. With over 20 cloud flows and a Power Apps app, the Approvals Kit offers sophisticated approvals such as conditional branching, delegation, admin overrides, and more. And the best part? You can configure all of this without writing a single line of code. Try the Approvals Kit now and see how it can empower every person in your organization to &#8216;do more with less&#8217; for your approval needs.</p>
Use Fabric Notebook to monitor Power BI semantic models - Phil Seamark on DAX
If you are starting to enjoy using Microsoft Fabric more, especially the exciting new Direct Lake storage mode, you may find this simple tip useful to help monitor your semantic models. The idea behind this tip is to run a DMV (can be any DMV) on a regular basis against a semantic-model and accumulate results … Continue reading Use Fabric Notebook to monitor Power BI semantic models