Power BI

Video by: Reid Havens Learn how to transform the native Matrix Table visualization in Power BI into an cool table heatmap by leveraging the conditional formatting feature.

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup135 2 Minute Tuesday: https://guyinacu.be/reportbackground Patrick’s tech video: https://guyinacu.be/slicerperf Adam’s tech video: https://guyinacu.be/nextlevelbutton Sources Creating a Table Heatmap in Power BI (@HavensBI) Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures (@cwebb_bi) Announcing Query Caching in […]

With the recent announcement around E-Mail Subscription support for Paginated Reports in Power BI, you can now have full PDF’s of those reports sent to your inbox on a regular basis. This has…

In some of my old posts, which are most popular ones, I explained how to Export data Power BI Desktop or Power BI Service data to different destinations like CSV, Excel and SQL Server. In this quick tip I explain a very easy way to export the model data as a whole to either CSV … Continue reading Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One Shot with DAX Studio

I usually wait a week or two to weigh in on new announcements from Microsoft. I like to let the noise die down a little, and see how others are responding to the news. But I am way too excited abou…

I have just modified from the PBIX file which I have seen in community and existing one has some off, so I have modified and publishing here. eyJrIjoiMTMwOTIwODEtYTdlMy00NGY4LThmYjYtNjM3MmJkZDAwMjcwIiwidCI6IjFkNTM2MDg1LTUzNmUtNGFmNS05NDliLTkxYzc0ODFiYjZhMyIsImMiOjF9

In a comment to the recent announcement of Workspace Management in the Admin Portal, JohnR asked for an option to export the list of workspaces with the fields provided. This would help facilitate admin work across thousands of workspaces. A great suggestion! Perhaps you wanted to export the list of workspaces placed on Premium capacities, … Continue reading “Exporting the workspaces list from the Admin Portal”

By using the Power BI management cmdlets, you can automate typical user and administration tasks with significantly less effort and complexity than with direct Power BI REST API calls. To illustrate this point, let’s take a look at Sirui’s original copyWorkspace.ps1 script, published in 2017 for the “Duplicate workspaces using the Power BI REST APIs: … Continue reading “Duplicating workspaces by using Power BI cmdlets”

As discussed in our blog post announcing support for Azure Analysis Services, we promised to unlock the critical capability of allowing Paginated Reports to be built on the same enterprise semantic…

Earlier today someone from one of the largest companies in the world asked "Is there any script for counting reports and dashboards in each workspace for the entire (premium) capacity?" The answer is …

Licensing has direct impact on the value of dataflows in Power BI for your organization Dataflows in Power BI sound great – and they are – but who truly benefits from this new element in the BI pro…

As organizations grow their Power BI deployments and foster a data culture, users will have an ever-increasing amount of data available to them. This wealth of information makes it critical to have tools to find and organize relevant content. Last September, we took the first step in improving our overall navigation experience by introducing a … Continue reading “Announcing Power BI Home General Availability (GA) & Roadmap”

One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web…

We are happy to announce that we have just released the April update for the On-premises data gateway (version 3000.3.138). Here are some of the things that we would like to highlight with this month’s release: Availability of the following connectors via the On-premises data gateway Oracle Essbase connector PDF support in File connectors. The … Continue reading “On-premises data gateway April 2019 update is now available”

As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you should you clean your data when building …

Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your Power BI Reports shine. Connect with Amanda on Twitter: https://twitter.com/MissAmandaN

If you have a lot of report pages in your Power BI reports you already realised that it is such a pain to click the left/right buttons to navigate through different pages. Well, you can simply right click on the left/right buttons which opens a list of your pages, then select a desired page. Easy! … Continue reading Quick Tips: How to Quickly Switch Between Report Pages in Power BI

In this post you learn how to conditionally replace values in Power Query (M) instead of adding unnecessary calculated columns.

In this post I explain what XMLA endpoints mean for Power BI and how you can create a test environment and connect from SSMS, Excel etc... to Power BI Premium

Makers can now easily add and move fields and controls, to the exact location they want, directly on the form preview, and instantly see how the form will appear to end-users. Two new features added to the new form designer: drag-drop and cut-paste are making this possible. Combined with the live WYSIWYG preview of the form, these new features provide a big productivity boost when authoring forms.

In Power BI, today, a new data source (cloud or on-prem) is created only if a successful connection can be made to the data source with the credentials provided. If it fails, the data source creation fails with an error message as shown below: The same applies to editing credentials for existing data sources. If … Continue reading “Skip Test Connection for On-premises and Cloud Data Sources”

When using PowerApps, we get a fair amount of settings to change our text controls but sometimes, we need that little extra touch. One of those options is the font family. We get 14 font styles that are suitable for most design ideas. We might get more in the future but now, I’m going to show you how to include any desired font that might be required for any of your projects. First approach, the HTML control The first idea that you might have tried is to use the powerful HTML control that is included in PowerApps. This control lets you format it’s contents using plain HTML code, but it has ...

<p>We launched the public preview of the Data Gateway administration feature on the Power platform admin center in January. This feature provides tenant admins with visibility into all On-premis…

Power BI real-time streaming is the perfect solution for IoT. Whether processing data through Azure Stream Analytics, the PubNub data stream network, or a custom Internet of Things solution, Power BI …

If you are using slicers in your Power BI report, moving them off to the filter pane could improve performance. Patrick shows you what this could look like based on a real customer story.

The second part of the series shows how to look and optimize your Power BI model so that it can be smaller and used inside Power BI Premium

Intro In this blog post we will explore a method for color control that not only aims to make app creation and color maintenance simpler but can also be easily extended to give users personalization options. We will start by setting up a basic color scheme data structure, use collections to pull t...

Today we have reached an important milestone for Microsoft PowerApps: we are announcing public preview for PowerApps component framework for model-driven apps. This is a significant step towards empowering 3rd party developers to build compelling visual components in PowerApps and Dynamics 365 using the same framework which the Microsoft team uses. Professional developers can now … Continue reading “The PowerApps component framework and the PowerApps CLI is now available for public preview”

There are several discussions regarding the use of CDS connector VS the Dynamics connector in the Power Platform. Recently I have been updating my knowledge a lot on PowerApps, PowerBI and Flow. Th…

Learn how to analyze categorical data in Excel with the use of Pivot tables [with video}