A Fine Slice Of SQL Server
Sandeep Pawar distributes PDFs like candy:
With the proposed solution below, you will be able to :
- Export a Power BI report, or a page of a report or a specific visual from any page as a PDF, PNG, PPTX or other supported file formats
- Apply report level filters before exporting
- Automate the extracts on a schedule
- Save the exported reports to specific folders
- Grant access to individual folders in the Lakehouse
Click through for the solution.
Leave a CommentGilbert Quevauvilliers builds a report:
How much data is being stored in my Fabric OneLake (Lakehouse files and tables)
I recently had a question from someone in the fabric community asking how much storage was being used by the Lakehouse and tables.
This got me thinking that currently there is not an easy way to do this.
Read on to see how Gilbert found the answer.
Leave a CommentKurt Buhler performs comparative analytics:
In a previous article about format strings, we showed an example of how format strings can improve visualizations. The visualizations in that article compared the performance of a company’s marketing videos on a streaming platform to the average of all their videos released that year. In this article, we explain how to conduct this analysis yourself in DAX, where you compare series that occur in different periods.
Click through for an explanation, both in video and in blog form.
Leave a CommentDavid Eldersveld talks licensing:
To facilitate a smooth transition from Power BI to Fabric (new capabilities), Microsoft ensured customers could access these new Fabric workloads as well as Copilot for Power BI on their existing Power BI Premium capacity P SKUs.
However, with the introduction of Azure-billed pay-as-you-go and annual reservation F SKUs for Microsoft Fabric, Microsoft recently announced the eventual retirement of the Power BI Premium per capacity SKUs that needs to consider an organization’s Enterprise Agreement (EA) timing.
Read on to learn more, especially if you currently have a Power BI Premium P1 (or higher) SKU.
Leave a CommentNikola Ilic reminds us to keep Ralph Kimball’s Data Warehouse Toolkit book at hand:
But, what is a star schema in the first place? I have good and bad news for you:)…The bad news is: I’m not covering it in this article, because this one focuses on explaining how to implement a star schema in Power BI (assuming that you already know what star schema is). The good news is: I’ve already written about it, so go and read this article first, if you’re not sure what star schema represents in the world of data modeling…
Now, let’s get our hands dirty and build a star schema!
Read on for the demo.
Leave a CommentRiqo Chaar get more than 80% of the way there:
The Pareto principle, commonly referred to as the 80/20 rule, is a concept of prioritisation.
It states that for many outcomes, 80% of the outputs are derived from 20% of the inputs. Although this isn’t a universal truth, this pattern has been observed in many different cases. For example, a large proportion (80%) of the revenue a particular business generates may primarily be associated with only a small proportion (20%) of big-selling products. This concept is related to the law of diminishing returns and poses the following question: If, after reaching a certain level of output (80%), significantly more effort is required to achieve further increases in this output, is this additional effort worth it?
In this article, we demonstrate the process (using DAX expressions) of creating a Pareto chart in Power BI.
Read on to see how you can build a chart like this. It’s a very popular style of chart for manufacturing scenarios.
Leave a CommentMarc Lelijveld builds a pipeline:
Recently, Microsoft released a new activity type to trigger Power BI Semantic Model refreshes. A great step forward to have a native pipeline activity and no longer need to setup complex steps with APIs and authentication manually. Or is there still a case?
In this blog I will elaborate on what this new Pipeline activity exactly is, various scenarios in which it can be applied and finally some edge cases and shortcomings.
Click through to see how it works.
Leave a CommentChris Webb gives us an update on internal join types and query folding in Power Query:
There are a couple of nice new features to do with table joins (or merges as they are known in M) and query folding in Power Query in the April release of Power BI Desktop that I want to highlight.
Read on for more information about anti-joins, semi-joins, and the ?? coalesce operator.
Leave a CommentGilbert Quevauvilliers skips the desktop step:
There have been some updates to Power BI with Visual Calculations, and as of the March 2024 release you can now create and edit visual calculations in the Power BI Service.
Here are details from the blog post: Power BI March 2024 Feature Summary | Visual Calculations Update
I then saw an email which made me think, could I then use the visual calculations to create a DAX measure directly in the Power BI Service on an existing Power BI report.
The answer, it turns out, is yes. Read on to see how.
Leave a CommentMarco Russo and Alberto Ferrari play the accordion:
In previous articles, we introduced the concepts of visual context, the visual lattice, and the two visual context navigation operations: EXPAND and COLLAPSE. In this article, we build on that knowledge to first compute a simple percentage over the parent: a simple calculation to consolidate the understanding of EXPAND and COLLAPSE. Next, we move on to a much more complex scenario, computing the inflation-adjusted sales using visual calculations.
Read on to see what the two functions do, using a pair of examples.
Leave a Comment