All about Power BI, Modelling, DAX and Microsoft BI
On this episode of Kasper On BI we are talking with Kim Manis, Kim is the group Program manager on the Power BI team responsible for all creation and consumption of content (this includes Power BI desktop). In this episode we talk about what how she got started at Microsoft and what it means to be a Program manager. We will also discuss how features at get prioritized; how do we pick the features to... Read more
I have been spending less time on blogging as I am spending more and more time on my new Kasper On BI format. In this episode of Kasper On BI we are talking about on making the journey from Excel to Power BI with Shannon Lindsey. Shannon has no computer background but gradually starting to work with data through Excel. Then she found PowerQuery in Excel which led to Power BI. We will talk about... Read more
I’m happy to launch my new “Kasper On BI” show. At Kasper On BI we will talk about everything Business Intelligence and its ecosystem. From DAX, report designing, ETL, modelling, Synapse and Big data. In every episode we will talk to an expert. I will ask them to share his or her experience on the topic, tips and trick and whatever we can learn. The show will be available on YouTube and as PodCast as... Read more
I have seen this question a few times. When incremental refresh is setup, we cannot refresh the whole model. Some workarounds are deploying the model again but that is not the best solution. There is a way if your model is running on a XMLA enabled capacity. You can send a TMSL command with our without incremental refresh. With Incremental refresh it looks like this: This will allow you to say which table needs to... Read more
AS we have seen calculation groups are great :). It offers amazing flexibility and is extremely easy to maintain. But sometimes it doesn’t do what you want due the limitations of the visuals. Let’s say I want to have a visual that shows me the sales of current year and sales Previous year on different axis (let’s say as line). You would create something like the visual below where you want to use the same... Read more
Initially I provided a TOM sample to create a calculation group, but you can also interact with the Tabular engine through TMSL using for example management studio. So here is code snippet you can run in your management studio that points to either AS or your internal Power BI desktop file. Make sure you set the compatibility level to at least 1500 and set DiscourageImplicitMeasures to true. This you can do by scripting out the... Read more
With the release of the July 2020 version of Power BI desktop we can create tools that can interreact with the Power BI Desktop model directly using an external tool. With this interaction you can make changes to the model in a programmatic way. There are so opportunities things this will open up. You can think of a tool that would allow you to edit the model like Tabular Editor or query like DAX Studio... Read more
Calculation groups are one the most exciting features in some time. At the time of writing there are no tools built into Power BI to create them though. You can add them programmatically though. To add them I wanted to play around with the tabular object model but more on this project later 🙂 . Unfortunately, there was not much documentation available on how to add calculation groups using TOM. Luckily, I have short access... Read more