Power BI
-
Introduction The new SQL Database item in Microsoft Fabric, just announced at Ignite last week, puts a new spin on my long journey of enabling write-back for Power BI reports powered by a Microsoft Fabric backend. Until the ‘Translytical Apps’ which were also teased at Ignite becomes a public thing (Video of sneak peek), using…
-
Introduction If you are looking for an easy to set up solution to monitor events in one or more Fabric Workspaces that you are responsible for, you can look into using Data Activator / Reflexes with the built-in Workspace Item Events data stream. In this blog we will explore how to connect and use this…
-
The simplest Version Control setup possible for Power BI: Sharepoint/OneDrive + automatic publishing
Introduction This blog has previously covered the great GIT Integration that has been made available for Fabric Workspaces, and its power in combination with Deployment Pipelines for proper Content Lifecycle Management: Simple Version Control in Fabric / Power BI with GIT Integration – a beginner’s guide – Downhill Data (downhill-data.com) Suggested architecture for collaborative Power…
-
Introduction Recently I posted my guide on Data Write-Back to Fabric Data Warehouse with Power BI and Power Apps: Live Data Write-Back to Fabric Data Warehouse from Power BI w. Power Apps and Power Automate – Downhill Data (downhill-data.com) That solution uses Power Automate to circumvent the traditional Power Apps x Fabric problem, of Fabric…
-
Introduction Half a year ago, I wrote a blog post on creating Measure Tables in Fabric Data Lakehouses directly in the browser: How to create Measure Tables in Microsoft Fabric – Downhill Data (downhill-data.com). Back then, Data Warehouses were less relevant for the story, as they could not be used for Direct Lake models, and…
-
Introduction Yesterday, I participated in the Swedish Power BI User Group to discuss a topic that has been heavily on my mind since the introduction of Microsoft Fabric. As a Power BI user and Data Analyst, how will I fare on a Platform with so many possibilities, and yet so many requirements? What will my…
-
Introduction What to you get when you mix the recently-gone-generally available Stored Procedure functionality in Power Apps with Stored Procedures in a Fabric Data Warehouse? A match made in heaven is what, I tell you. This blog will introduce you to the general principles of working with Stored Procedures in Power Apps (not just for…
-
Introduction I’ve previously written about sharing Power BI Reports with Externals, both through Power BI Embedded (using Power Pages) and to guest users in the Power BI Service. However, a new addition to the line-up of capabilities in Microsoft Fabric allows us to share Semantic Models directly with external users as well, enabling entirely new…
-
Introduction Hierarchies in Power BI are a blessing and a curse. From an End User perspective, they provide great context, and may acts as funnels guiding analysis. But from a developer point-of-view, they often also come with a range of not-so-basic requests. Have you for example encountered one or more of the following user requests?:…
-
Introduction An overlooked feature of Power BI, is the ability to create deep links for specific Report Pages, to aid users in navigating to a specific place in your report, decided by you, the report developer. Combined with the ability to add filters to these deep links, and you have a super powerful way to…
Downhill Data 