Export the Entire M Power Query Script from a Power BI File, New Version of Power BI Helper, Search based on Field Description in the Model

Previous versions of Power BI Helper had some features related to the visualization part and the modelling part of a Power BI file. This latest release of Power BI helper, can export the entire M or Power Query script into a file or into clipboard. Sometimes, especially when the number of queries in the Power Read more about Export the Entire M Power Query Script from a Power BI File, New Version of Power BI Helper, Search based on Field Description in the Model[…]

Creating Machine learning Development and Production Environment in Power BI-Part2

In the last post, I have explained how we can create a function with the aim of parametrising the machine learning process. In this post, I am going to explain how we able to create a Development and Production environment. Create Different Environment in Power Query to create a new environment, In power query, I Read more about Creating Machine learning Development and Production Environment in Power BI-Part2[…]

Dynamic Date Range from Slicer

A recent post on a community.powerbi.com forum asked if it was possible to show a slicer of months, and configure a report so when a user selects a single month from the slicer, visuals will show data for a date range relative to that selection e.g. the preceding  10 months of data. If a user Read more about Dynamic Date Range from Slicer[…]

Embed Power BI in SharePoint Online; Office 365 Integrated Sharing

So far, you’ve learned about four ways of sharing Power BI content. In this post, you’ll learn about another method of sharing which is named Embed in SharePoint online. Embedding in SharePoint online is an excellent method to share Power BI content through a SharePoint portal. Because Power BI and Office 365 accounts are bound Read more about Embed Power BI in SharePoint Online; Office 365 Integrated Sharing[…]

Creating Machine learning Development and Production Environment in Power BI

  There is need to isolate the development and production environment in most of all projects. Setting up these environments help us to deliver a more reliable product to our customers. Machine learning projects also need a development, Test and Production environment. In this post, I am going to show you how we can do Read more about Creating Machine learning Development and Production Environment in Power BI[…]

Power BI – Banding and stripes in charts

This blog will show a technique that can be applied to certain charts allow banding or stripes to help highlight data. This could be horizontal bands to help show data above or below a certain threshold, or this could be vertical bands to help highlight ranges of data by time.  In both cases, using What-If Read more about Power BI – Banding and stripes in charts[…]

Power BI Publish to Web – Questions Answered

You’ve learned about three different ways of sharing content in Power BI so far. All of the methods that we talked about before (Dashboard Sharing, Workspaces, and Power BI Apps) need paid power bi subscriptions for consuming reports. Users need to be either Power BI Pro or free accounts under Power BI premium capacity. Publish Read more about Power BI Publish to Web – Questions Answered[…]

Power BI Desktop; Getting Started – Part 1

  There are some reasons that I chose Power BI Desktop for the very first demo of this book. Power BI Desktop has three components all in one (Power Query, Power Pivot, and Power View), it can upload directly to Power BI website, and it is a recently released product with many shining features. In this section Read more about Power BI Desktop; Getting Started – Part 1[…]

Python Programming-Environment

Python is one of the famous programming languages and it is so common for Machine Learning. It is a multi-purpose language that has been leveraged with the aim of device programming, object-oriented programming, machine learning and so forth. In this post, I will introduce some of the common Python IDE programming environment for the aim of Read more about Python Programming-Environment[…]

Ultimate Sharing Strategy: Power BI Apps

You’ve learned previously about some of the methods of sharing content in Power BI, such as Workspaces, and Dashboard Sharing, Publish To Web, and Content Pack. In this post, I’ll explain everything about new Power BI Apps; a mechanism to share the content in Power BI in a way that has security and governance together. Read more about Ultimate Sharing Strategy: Power BI Apps[…]