Power BI

Here is how to manage that you always import all columns from the CSV file with Power Query. That is useful if file gets additional columns.

Hybrid tables are one of the most powerful features in Power BI! And, it's not (just) about separating "hot" and "cold" data...You can basically leverage hybrid tables in whole spectrum of business scenarios

New admin APIs to retrieve email subscriptions and widely shared reports

Let’s set up some basic Source Control in Power BI, with Tabular Editor, Azure DevOps/Git & Visual Studio! In this post, I give a brief step-by-step tutorial on setting up basic Source Control in Power BI, and explain how Tabular Editor helps your source control in Power BI, by lever

It’s no big secret that source control is challenging in Power BI. There are few native tools which enable source control in Power BI, allowing you to track changes and work collaboratively with colleagues on a Power BI dataset. Thankfully, however, external tools make this quite easy, for example

The latest updates can always be found in thePowerBI.CICD repository In the past I have been working on a lot of different Power BI projects and it has always been (and still is) a pain when it comes to the deployment of changes across multiple tiers(e.g. Dev/Test/Prod). The main problem here being that a file…

After Power BI Workspace setup – part 1, which was mainly about creating your workspace, giving it the right name etcetera, this blog will elaborate on workspace permissions. If you did not r…

Video by: Reid Havens Learn how to change the color of columns in a chart that are above or below an analytics line . RELATED CONTENT 🔗 Improved Dynamic Analytics Line Dynamic Analytics Line

At Excel, customer focus is at the core of what we do. We appreciate your feedback on adding autocomplete to data validation dropdown lists in Excel for Windows. Your Excel Community votes ensured this was one of the next in line to release after smooth scrolling. Thank you for keeping us honest and...

In my last post I showed how to use Log Analytics data to analyse Power BI query activity. The problem with looking at a long list of queries, though, is that it can be overwhelming and it can be h…

This article introduces the syntax to describe in a textual form the DAX expressions and additional properties of calculation groups. When calculation group

Deneb JSON Template for Joy/Ridgeline plot with independent scales

I’ve listened to music on Spotify for over 5,000 hours since I subscribed to their service. I listen the most in the early morning when I’m at the gym and before my morning meetings beg…

Do you know who is the biggest "enemy" for the optimal data model size? Meet the Cardinality, and learn how to boost the report performance applying some simple techniques for improving cardinality levels

Starting with the next Power BI Desktop release, WebView2 will be required. If you have not switched over yet, please take action now to avoid interruptions.

Unless you’re building a solution for your exclusive personal use, you are not the customer. If you are not the customer, you need to invest in understanding the customer’s motivations,…

QuerySurge’s BI Tester provides connectors for Microsoft Power BI, Tableau, Microstrategy, IBM Cognos, SAP, and Oracle OBIEE.

How can you create your own data types in Excel? Oh yes, you can do it! In this article, we'll learn how you can create data types in Power Query.

Information The report shows the performance of the S&P 500 index which comprises 505 common stocks issued by 500 large-cap companies traded on American stock exchanges.  The report contains data for the last 1 year and is updated daily.   Data Sources The main source of data is Yahoo Finance. To pu...

If you want to learn Tabular Editor, this is a good place to get started. This is a walk-through of some basic settings and uses of the tool, including how to find your way around and customize the user interface, and create, modify and organize objects in the model.

This post gives a good overview of the different functionalities and design options of slicers in Power BI. For professional looking reports.

In this blog post I show you how to easily use Power BI Embedded and use your own reports to see what it looks like.

We’re excited to bring you a new version of Power BI Report Server this Winter! With the January 2022 update, we have a variety of new enhancements, including page and bookmarks navigators, new sorting options for legend, new formatting options for text, pie and donut chart rotations and many more.

Process mining, provides direct data insights across an organization’s daily business processes, helping identify inefficiencies to improve how they work. Now with the preview of process mining in process advisor, leveraging Power BI Embedded , you can use your business data to produce analytics and detailed process maps, gleaning new insights into ways to optimize your business processes.

The creation of the electronic spreadsheet transformed industries. But its effects ran deeper than that.

This article explains provides an introduction to relationships and why relationships can be considered a sword that helps to chop vast amounts of data into tiny pieces.

Hybrid table is a Clever technical solution to a very fundamental problem in Data Analytics, How to keep Data fresh and at the same time fast, PowerBI , Tableau, Qlik solved this problem by importi…

Log Analytics contains information on the dataset, report and visual that are associated with a DAX query but that information is in the form of IDs rather than names. Getting the IDs for specific …

If you thought that MapBox was good, well you’re going to LOVE the Icon Map custom visual in Power BI – which allows you to display interactive polygons, points, lines and of course – icons, all in the one visual…plus so much more! In this blog I walk through two of DiscoverEI's project examples of