Today, I’ll show you how to connect Power BI to R and showcase the things you can do with the R script visual in Power BI. In order for this to work, you need to have R installed in your computer since it comes completely independent from Power BI. To get started, let’s click on
When doing an analysis on our model, we might want to find an insight that’s unrelated to anything within our tables. That’s where the concept of using supporting tables for Power BI data modeling comes in. Supporting tables don’t have any relationship with our tables, but we can use them to support the visualizations in
In this blog, we’re going to learn about some essential Power BI filtering techniques for tables. We’ll discuss some simple techniques that we can utilize when we have massive tables on our query. For example, when we need to extract information from a database or an ERP system, it could have 10 million rows within
For today’s blog post, I’ll talk about the newly available Deneb Vega-Lite custom visual for Power BI, which I used exclusively in my partial submission for the Enterprise DNA Challenge #17 on environmental data reporting. You can watch the full video of this tutorial at the bottom of this blog. This received some positive feedback,
Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column to put them in proper order. I experimented with this new approach and it worked beautifully. In
