Power BI

The Web.Contents() function in M is the key to getting data from web pages and web services, and has a number of useful – but badly documented – options that make it easier to construct urls for yo…

Contribute to franmer2/AzurePurviewChargeBackReport_Us development by creating an account on GitHub.

Microsoft Power Platform: 2021 release wave 2 plan6 minutes to readThe Microsoft Power Platform release plan for the 2021 release wave 2 describes new features releasing from October 2021 through March …

Microsoft Power Platform: 2021 release wave 2 plan6 minutes to readThe Microsoft Power Platform release plan for the 2021 release wave 2 describes new features releasing from October 2021 through March …

Using Power Automate? Using Power BI? Why not put the two together for some interesting scenarios. Patrick uses the Power Automate visual, in a Power BI report, to send emails out. Power Automate: https://flow.microsoft.com/ Blog Announcement: https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-automate-visual-for-power-bi-reports/ Documentation: https://docs.microsoft.com/power-bi/create-reports/power-bi-automate-visual

In this blog, let's explore the prerequisites, steps, and limitations of connecting Power BI datasets in Tableau using the Microsoft Analysis Services connection.

It has been quite a while since my last blog post. The major reason for this is that my company IT-Logix decided to start its own blog. So I wrote a few articles, all of them in German. Therefore i…

“We now do Agile BI too” – such statements we hear often during conferences and while discussing with customers and prospects. But can you really do agility in Business Intelligen…

As outlined in my previous blog agility in business intelligence projects can’t be produced directly. Instead you should invest into professionalism, standardization and automation. In this p…

Problems of requirement analysis Practically every BI project is about requirements, because requirements communicate “what the client wants”. There are essentially two problems with th…

Quite a while ago, I published a blog post about my Agile BI Maturity Model. In this post I’d like to show you the current state of the model. First of all I renamed the model to “Agile…

On-premises data gateway (standard and personal mode) release for July 2021

Posts about Agile BI written by Raphael Branger

Achieving BI agility is simple, once you have the right tools. By integrating BI tools in Jira, you can analyze project data at your fingertips.

Back in May 2021, we announced the integration of the new Power BI quick create experience within SharePoint, which enabled the SharePoint users to easily generate awesome Power BI reports by just one click. Currently, we are exploring other applications where we could potentially integrate a similar experience and one of the application that we are exploring is MS Forms. We have created a survey to compile feedback from our customers on a potential integration with Microsoft Forms. If your organization uses Microsoft Forms and/or Microsoft Power BI, we would encourage you to make your voices heard by completing this ~5 mins survey.

Learn how to leverage the power of calculation groups to activate inactive relationships without creating multiple measures!

[vc_row][vc_column width="1/1"][vc_single_image media="88181" media_width_percent="100"][vc_column_text]In this Power BI tutorial, you'll learn how to filter based on a measure value! In this […]

This is a follow up article from my last blog post where I demonstrated how easy it is to use two slicers to compare any two items. In the demo in my article, I specifically showed how you could compare any 2 years of choice, but the principle applies to [...]Read More »

Learn how easy you can create a fully-fledged calendar table in Power BI using a DAX script just by copy and paste into your file.

Are you new to Power BI? Maybe you've been using it for some time but you're still not sure how the end to end process works? This flowchart was made for the users that are still in the beginning of their Power BI journey! In my diagram, I divided the report development process into four main steps: 1) Analyse data and build your data model 2) Report Design 3) Prepare to share your report 4) Share your report In this post, I'm going to guide you through each one of the steps, and share some usef

I'm going to start this post by saying that it will be a bit different from the posts I've written before. Today, I will be sharing with you my ideas around core Power BI skills, and how I see them changing in the future. I'm very interested in learning about your experiences and your opinions around this topic as well, so please share your thoughts on the comments below. All points of view are valuable! If you work with Power BI already, you probably agree with me when I say that over the years

Some of the biggest changes in Power BI are rolling out this year. Premium Gen2 being the biggest of them. If you are a Power BI admin, check this list out!

Why is my report slow? What could I do to prevent my report from becoming slow? I hear these questions a lot, and the truth is, there is no silver bullet. If you've built your report already and you noticed the performance is not as good as you thought it would be, there are multiple reasons why this can be happening. In this case, it's important that you understand the root cause of the problem, as it's the only way to quickly fix it. In this blog post, we are going to focus on the second quest

What is referential integrity and why you need to make sure you have it. Learn how you can find and solve issues with it.