I just returned from the Microsoft Fabric Community Conference in Las Vegas. Over 4,000 attendees saw a lot of demos showing how to effortlessly build a modern data platform with petabytes of dat...
https://sqlserverbi.blog/2024/03/29/direct-lake-and-directquery-in-the-age-of-fabric/
Fabric is here but what does that mean if you are using Power BI? What do you need to know and what, if anything will you need to change if you are a Power BI report designer, developer or BI sol...
https://sqlserverbi.blog/2024/03/18/moving-from-power-bi-to-microsoft-fabric/
In my view, projects and teams of different sizes have different needs. I described DevOps maturity as a pyramid, where most projects don't require a sophisticated DevOps implementation, and the ...
https://sqlserverbi.blog/2024/02/01/ci-cd-devops-for-power-bi-are-we-there-yet/
Please come to the Atlanta SQL Saturday BI Edition in February, and join me for a full-day preconference event: Designing and Developing Enterprise-scale Solutions with Power BI
https://sqlserverbi.blog/2024/01/17/power-bi-for-the-enterprise-precon-atlanta-feb-9th/
Are you in the California Bay area? Do you want to learn to do Power BI and Fabric the right…
https://sqlserverbi.blog/2023/09/06/conference-sessions-and-presentations-in-2023-early-2024/
The enterprise Business Intelligence and IT community have been anxiously awaiting this capability for many years and it has finally arrived - at least in Preview form for testing and prototyping...
https://sqlserverbi.blog/2023/06/18/introducing-the-new-power-bi-project-and-why-it-is-important/
Microsoft Fabric (#MicrosoftFabric), the new Unified Analytics platform, was announced this morning, literally moments before the Build Conference. Satya made the official announcement in the key...
https://sqlserverbi.blog/2023/05/23/how-does-microsoft-fabric-change-the-enterprise-bi-game/
The Lakehouse is the evolution of the earlier cloud data platform in many pieces that came with "some assembly required". All of the components are modern, mature and capable but complicated and ...
In a recent blog post, Paul discussed that DevOps, and specifically CI/CD, principles are essential for modern software development, and Power BI is no exception. Power BI CI/CD for enterprise cl...
https://sqlserverbi.blog/2023/04/07/devops-ci-cd-for-power-bi-2/
Business users often need to know how fresh the data is that they see on a Power BI report. This requirement can be interpreted to mean either "when was the last date & time that the source data ...
https://sqlserverbi.blog/2023/02/08/creating-a-last-refresh-date-measure/
There is no secret about this. If you do any legitimate research about Power BI (reading blogs, books or training from reliable sources), you will quickly learn that a lot of basic functionality ...
https://sqlserverbi.blog/2023/02/05/power-bi-and-the-dimensional-dilemma/
DevOps isn't difficult to implement for small and medium-scale projects, and simple things like managing version control in a code repository can save hours of lost time. Organization who are acc...
https://sqlserverbi.blog/2022/12/29/devops-ci-cd-for-power-bi/
Power BI is architected to consume data in a dimensional model, with narrow fact tables and related dimensions. Introducing a big, wide table in a tabular model is extremely inefficient. It takes...
https://sqlserverbi.blog/2022/11/24/developing-large-power-bi-datasets-part-3-detail-tables/
Table partitioning has long been an important task in semantic model design using SQL Server Analysis Services. Since SSAS Tabular and Power BI models are built on top of the SSAS architecture, t...
https://sqlserverbi.blog/2022/11/23/developing-large-power-bi-datasets-part-2-partitioning/
When planning a Power BI solution, how can we plan for scale and growth? Like any technology, Power BI has limits but Power BI can manage a surprising large value of analytic data. We also have t...
https://sqlserverbi.blog/2022/11/17/developing-and-managing-large-power-bi-datasets-part-1/