News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
Quick Tips: On-premises Data Gateway, Network Ports Test - BI Insight
The latest version of On-premises Data Gateway February 2019 (3000.1.257) has been released on 1st March 2019. The release note is quite short and it doesn’t really provide a lot of information. At least that’s the case as at today (6 March 2019). There is One new feature however, that I found very interesting is … Continue reading Quick Tips: On-premises Data Gateway, Network Ports Test
Introducing Power BI Governance and Adoption Good Practices Series - BI Insight
In my experience working in IT industry from early 2000 one aspect of dealing with data that is always taken very seriously is data governance. For many years the industry learnt how important it is to have a data governance process in place to keep your data safe and healthy so you get the most … Continue reading Introducing Power BI Governance and Adoption Good Practices Series
DAX Measure Dependencies in SSAS Tabular and Power BI
In this post you learn how to leverage DMVs to get SSAS Tabular and Power BI Model object dependencies. It is easy to find DAX Measures dependencies, calculated column dependencies and much more. I made a tool in Power BI which is available for you to download for free.
Power BI Ecosystem Report Authoring Tools Demystified - BI Insight
There are a lot of discussions these days around Power BI tools to create reports and for sure many of you may have already downloaded and worked with some of them if not all of them. You may already think that some of the tools’ names are confusingly similar. I recently had an interesting conversation … Continue reading Power BI Ecosystem Report Authoring Tools Demystified
Quick Tips: How to Quickly Switch Between Report Pages in Power BI - BI Insight
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
Quick Tips: How to Filter a Column by another Column from a Different Query in Power Query - BI Insight
A while ago I was visiting a customer that asked if they can filter a query data by a column from another query in Power BI. And I said of course you can. In this post I explain how that can be achieved in Power Query. The key point is to know how to reference … Continue reading Quick Tips: How to Filter a Column by another Column from a Different Query in Power Query
Quick Tips: How to Sort Matrix by Column in Descending Order - BI Insight
Today Microsoft released Power BI Desktop March 2020 which I was hoping that it includes a simple feature on Matrix visual to be able to sort the Martix by column in descending order, but, it doesn’t. So, in this post I quickly show you how to sort Matrix by column in descending order. Here is … Continue reading Quick Tips: How to Sort Matrix by Column in Descending Order
Four Different Ways to Find Your Power BI Desktop Local Port Number
Update December 2023: From the October 2023 release of Power BI Desktop onwards, there is a 5’th method to find the port number within the Power BI Desktop itself. This method is explained here. About two years ago I wrote a blog post on how to connect to a Power BI Desktop model from different … Continue reading Four Different Ways to Find Your Power BI Desktop Local Port Number
Empower Your Story Telling Data Visualisation in Power BI with Colour Coding - BI Insight
This post has been waiting in my blogging list for a while and now this is my last post in 2019. I wish you all have a wonderful year ahead. In this post I discuss a very important aspect of data visualisation; Colour Coding. I believe, colour coding is one the most powerful and efficient … Continue reading Empower Your Story Telling Data Visualisation in Power BI with Colour Coding
Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods - BI Insight
Update 2021 March: You can now export the data direct from Power BI Desktop using my tool, Power BI Exporter. Read more here. Update 2019 April: If you’re interested in exporting the data model from either Power BI Desktop or Power BI Service to CSV or SQL Server check this out. The method explained here … Continue reading Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods
Preparing On-premises Data Gateway Implementation Plans for Enterprises - BI Insight
If you are a Business Intelligence consultant working on Power Platform, Azure Logic Apps and Azure Analysis Services landscape, you probably know that On-premises Data Gateway cab be one of the most essential parts of your engagements with your customers. In many cases, installing On-premises Data Gateway can be a one-man-band job but in many … Continue reading Preparing On-premises Data Gateway Implementation Plans for Enterprises
Visualise SQLite Data in Power BI
As the name implies, SQLite is a light weight transactional SQL database engine. It is open-source and free for use either for personal commercial. SQLite is widely used in mobile apps and many other desktop applications that need an internal light weight free SQL database. In this post I explain how to visualise SQLite data … Continue reading Visualise SQLite Data in Power BI
Highlighting Below Avg Sales per Hierarchy Level with SWITCH() and ISINSCOPE() DAX Functions in Power BI - BI Insight
I was working on a project a wee bit ago that the customer had conditional formatting requirement on a Column Chart.They wanted to format the columns in the chart conditionally based on the average value based on the level of hierarchy you are at.Here is the scenario, I have a Calendar hierarchy as below: Calendar … Continue reading Highlighting Below Avg Sales per Hierarchy Level with SWITCH() and ISINSCOPE() DAX Functions in Power BI
Quick Tips: Line Chart and Area Chart Conditional Formatting in Power BI - BI Insight
In this post I show you a very quick trick to format Line Chart and Area Chart conditionally in Power BI. As this is a “Quick Tip” I’m going to keep this post really short. One of my customers asked me to show time series in line charts and area charts. But she want’s it … Continue reading Quick Tips: Line Chart and Area Chart Conditional Formatting in Power BI
Pass BI DW, Power BI Under the Hood Webinar Materials
I’d like to thank you all for attending the webinar held on 30th September 2016. I talked about some amazing under cover aspects of Power BI Desktop model. In this session you learnt: how to find Power BI Desktop local port number how to connect to Power BI Desktop model from Excel and SQL Server … Continue reading Webinar Materials: Power BI Under the Hood
Power BI Governance, Good Practices, Part 2: Version Control with OneDrive, Teams and SharePoint Online - BI Insight
One of the most important aspects of the software development life cycle is to have control over different versions of a solution, especially in a project where there is more than one developer involved in the implementation. Just like when you normally create a project in visual studio and you commit the changes back to … Continue reading Power BI Governance, Good Practices, Part 2: Version Control with OneDrive, Teams and SharePoint Online
Azure Data Lake, Azure Analyses Services, Power BI and How They Relate
I recently spoke in Tampa Dev Azure Meeting in a webinar form on 31st Jan 2018. We received interesting questions during the presentation. My aim was to introduce basic concepts of Big Data, Azure Data Lake, Azure Data Lake Store (ADLS), Azure Data Factory (ADF) and Power BI. I would like to thank Tampa Dev … Continue reading Azure Data Lake, Azure Analysis Services, Power BI and How They Relate
Good Practices: Always Display the Reporting Environment - BI Insight
When you work on real-world projects in power BI, you would probably have different environments Like DEV, UAT, Pre-Prod and Prod. It is important for you and your audience to know what the data is coming from. Am I looking at Dev or UAT data or I am actually looking at real data in Production … Continue reading Good Practices: Always Display the Reporting Environment
Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One-Shot with DAX Studio - BI Insight
Update 2021 March: You can now export the data direct from Power BI Desktop using my tool, Power BI Exporter. Read more here. In some of my old posts, which are the most popular ones, I explained how to Export data Power BI Desktop or Power BI Service data to different destinations like CSV, Excel … Continue reading Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One-Shot with DAX Studio
Analyse Your WordPress Website Stats in Power BI
WordPress is one of the most popular open-source website making tools which is vastly used by many bloggers including myself. WordPress developers provide tons of custom plugins to fulfil different needs. But not all of the plugins are well designed and secured. One of the most interesting pieces of information anyone who owns a website/blog … Continue reading Analyse Your WordPress Website Stats in Power BI