How to Disable Custom Visual in Power BI Desktop Model

Update Sep 2022: I wrote this blogpost in Mar 2016. Power BI Desktop improved a lot since then. Currently, Power BI Administrators can Enable or Disable custom visuals for the reports published to Power BI Service from Power BI Admin Portal across the organisation or to certain security groups. There are also some settings for system administrators to Enable or Disable custom visuals on the user’s Power BI Desktop across the organisation via group policy settings. The users can also remove custom visuals from Power BI Desktop by following these steps:

  1. Clicking the ellipsis button on the Visuals pane
  2. Clicking Remove a visual
  3. Selecting the custom visual
  4. Clicking the Remove button
Removing Custom Visuals From Power BI Desktop
Removing Custom Visuals From Power BI Desktop

Disclaimer: The method described in this post includes modifying Power BI file (PBIX) outside of Power BI Desktop. It is highly recommended to take a backup of your PBIX file beforehand. It’s highly probable that you corrupt your PBIX file if make a mistake when following the method described here. So please follow the process on YOUR OWN RISK!

Custom visuals are awesome. It’s easy to import them to Power BI Desktop model and start using them. But, what if you decide to remove them from your model? Is there a way to disable an imported custom visual?

Well, the answer is No and Yes! I mean, NO, there is no specific setting or option you can manage imported custom visuals in Power BI Desktop. But, YES, there is a way you can get rid of an existing custom visual. In this article I show you how to do the job.

First of all, I’d like to inform you that Microsoft will add the feature to disable custom visuals in Power BI Desktop, but, until then you can follow the my trick to completely disable/remove a custom visual from your Power BI Desktop model.

As you might already know a PBIX file is a compressed file indeed, so you can open it with a ZIP editor software like 7-Zip.

Requirements:

  • Download and install 7-Zip. It’s a free open source file archiver/compressor
  • Download and install Notepad++ which is also free and open source. It’s an awesome text editor

Removing/disabling Custom Visual

  • Open you Power BI Desktop model (PBIX file) containing a custom visual
  • As you see you need to enable custom visuals, click “Enable custom visuals”
Enable Custom Vizuals
  • I used “KPIStatusWithHistory” custom visual in my sample model
Custom Vizuals
Continue reading “How to Disable Custom Visual in Power BI Desktop Model”

Connect Live Power BI to SSAS Multidimensional

Connect liv Power BI SSAS Multidimensional

In one of my previous posts I explained how to use Power BI on top of your SSAS Multidimensional using Data Import Scenario. You can also find definitive explanation about “Managing Analysis Services Multidimensional Model” here. In this post I show you how to connect live your SSAS Multidimensional model with Power BI. “Connect Live SSAS Multidimensional” means making a Direct Connection from Power BI Desktop to your SSAS Multidimensional instance.

As it is a direct connection you’ll be able to see/use the following SSAS Multidimensional objects:

  • Cubes
  • Perspectives
  • Measure Groups
  • Measures
  • Dimensions
  • Dimension Attributes
  • Hierarchies including Parent Child

In this post you’ll learn:

  • How to connect live from Power BI Desktop to SSAS Multidimensional
  • Creating reports using SSAS objects like hierarchies
  • Publishing your reports from Power BI Desktop to Power BI Service

Requirements

To be able to successfully create and publish your reports using Power BI Desktop on top of SSAS Multidimensional you will require:

  • The latest version of Power BI Desktop (Current version is 2.31.4280.361 64-bit (January 2016))

Power BI Desktop Version

Continue reading “Connect Live Power BI to SSAS Multidimensional”

Webinar Materials: Visualising Azure SQL DW with Power BI

Power BI Azure SQL DW PassIn the previous post I announced that I will speak in “Visualising Your Azure SQL Data Warehouse with Power BI” webinar on 23 Jan 2016. The webinar host was Pass Business Intelligence Virtual Chapter. It was such an amazing experience for me to speak in the webinar and I would like to thank all 105 attendees. The attendees showed their enthusiasm by asking lots of questions during the webinar.

In this webinar I demonstrated:

  • How to install Azure SQL DW in Azure Portal
  • How to configure firewall settings from Azure Portal and SQL Server Management Studio (SSMS) 2016
  • How to connect directly from Azure SQL DW to Power BI Service and the other way around
  • How to visualise you Azure SQL DW data warehouse data with Power BI Desktop (both Data Import and DirectQuery scenarios)
  • Comparing the features of different scenarios that helps you finding the best for your use cases

and much more…

You can see and download the session materials as follows.

Session Materials

Watch Visualising Your Azure SQL Data Warehouse with Power BI on YouTube

Continue reading “Webinar Materials: Visualising Azure SQL DW with Power BI”

Webinar: Visualising Your Azure SQL Data Warehouse with Power BI

Pass BI Virtual Chapter Visualizing Azure SQL Data Warehouse Power BI

It’s such an honor that I’m invited to speak in Pass Business Intelligence Virtual Chapter webinar which will be held on 23 Jan 2016.  I would be very happy to have you all in the webinar.

You can register here.

You can register and subscribe for Pass upcoming events here.

Agenda:

  1. Introduction to Power BI
  2. Introduction to Azure SQL Data Warehouse
  3. Requirements
  4. Demo
    • Azure SQL Data Warehouse Installation/Configuration
    • Connecting Directly from Azure SQL Data Warehouse to Power BI Service
    • Creating Simple Reports on Power BI Service
    • Visualising Azure SQL Data Warehouse Using Power BI Desktop
  5. Conclusion

Continue reading “Webinar: Visualising Your Azure SQL Data Warehouse with Power BI”