Power BI
Microsoft Fabric Tutorial: How to Use Dataflow Gen2 for Data Transformation
This is the second video in a 3-part Microsoft Fabric basics tutorial series, where we will show you to use Dataflow Gen2 for data transformation. In my last video, I talked about how to create a lakehouse and create shortcuts in Microsoft Fabric. We established a lakehouse and its sequel analytics endpoint. Additionally, we developed…
Read MoreMicrosoft Fabric Tutorial: How to Create a Lakehouse & Shortcuts
This video walks you through some basics of Microsoft Fabric. I’ll show you how to create a lakehouse in Fabric and how to link to external data sources using an ingestion method called shortcuts. After that I’ll demonstrate how to create a semantic model and finally, how to connect to the semantic model and create…
Read MoreYour Guide to Power BI Licensing in the Microsoft Fabric Era
Licensing in the Microsoft Fabric world has never been a straightforward path. There are always permutations, alternatives, and perspectives on the best path for enterprise deployment. Microsoft’s leap forward with Fabric combines the best of the Power BI, Azure Synapse Analytics, and Azure Data Factory worlds. It has also introduced new wrinkles that need to…
Read MoreHow to Automatically Update Partitions in Power BI Semantic Models
Often when working with large semantic models, we see fact tables with many partitions. A common pattern is to partition by a date grouping (ie month, quarter, etc). Partitioning a fact table this way can provide many benefits: greater control over refreshes, faster refresh times, ability to re-run specific partitions if needed. This approach also…
Read MoreTransform Your Data Insights: Unleash the Power of OmniAnalytics D365 Business Central
Specifically built for Business Central and powered by Microsoft Fabric, OmniAnalytics™ offers a game-changing solution that will transform the way you work with data. With user-friendly data models and dozens of pre-built reports, it provides the fastest and most efficient path to achieving enterprise-grade analytics. We have provided a series of videos to share how…
Read MorePower BI Dataset Refresh Part 2 – Confirming a Dataset Refresh
Welcome to Part Two of this two-part video series on dataset refresh from Power BI within our Synapse Analytics pipeline using Power BI REST API presented by OmniData™’s Principal Solutions Architect, Ray Marquina. In this second video of our two-part series, we will be exploring how to check the status of whether or not a…
Read MorePower BI Dataset Refresh Part 1 – Trigger a Dataset from Power BI using REST API
Welcome to another two-part series for Tech Talk Thursday hosted by Ray Marquina, OmniData™’s Principal Solutions Architect. In this series, we will be exploring how we can trigger a dataset refresh from Power BI within our Synapse Analytics pipeline using Power BI REST API. In this Part One video, we will be exploring the following:…
Read MoreUnlocking the Power of Sharing and Distribution with Power BI and OmniAnalytics™
When adopting a new reporting or analytical solution, organizations devote a lot of time and resources into standing up their library of reports, but then what? Typically there isn’t as much thought or consideration into how to make these reports accessible and empower business users to make data-driven decisions. The scenario is especially true when…
Read MorePower BI Tips & Tricks: Group Values
Are you building back-end fields, over and over, to group existing data points for additional reports in Power BI? Or maybe you’re adding a new column in the database when you want to create a new report group? Did you know you can create new groups and information-packed reports with a few mouse clicks instead?…
Read MorePower BI Tips & Tricks: Faster Power Query
Extracting relevant, insightful business information from your critical data sources is significantly streamlined with Power BI using Power Query. But Power Query can be slow, especially if you’re capturing information from multiple databases, tables, and other sources in Azure. Streamline your ETL, or data Extract, Transform, and Load operations in Power Query with a few…
Read More