Multiple conditions for a conditional column in Power Query
I am often working on datasets where there is more than one condition for a conditional column. And whilst the GUI based Conditional column is really good, it currently does not have the capability for multiple conditions. In this blog post below, I will demonstrate…
Power BI RoundUp – Help Shape the Future of Power BI – On-Premise Update for Nov 2018 – Modeling View – Analysis Services is 20 years old!
Here is my weekly roundup, and whilst it has not been as busy as the past few weeks, there are still some awesome updates. Power BI – Help Shape the Future of Power BI I always think it is really important to provide feedback, especially…
Refreshing data in Power BI from SQL Server Read-only or Secondary Replica’s
I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M connector, it is available in the OLE DB connector. NOTE:…
Power BI RoundUp – (Nov 2018 Desktop release – AI Capabilities for Power BI)
Well this month has sure been a busy month with a whole host of additional updates for Power BI. I personally am really looking forward to the next few months to better understand how all of this will evolve and assist customers on leveraging their…
Power Query – A function to remove spaces within Text values
UPDATE: 19 Nov 2018 With the recent announcement of dataflows in the Power BI Service, I see more people will be looking to better understand and leverage dataflows by using the M language which is available in Power BI Desktop, Power Apps and Microsoft Flow….
Power BI RoundUp with SQL Pass updates – Dataflows – Paginated Reports (SSRS) – Premium Metrics App with Data Flows & Paginated Metrics – Paginated Reports in Mobile App – Mobile & Service Update for Oct – Bonus features coming to Power BI Desktop
As expected this week with SQL Pass, there has been a whole host of new capabilities and features in Power BI, so please see my roundup below with the relevant links below. And even though there is a lot of announcements here, we are still…
DAX Measure – Getting Difference between 2 values in a table
I had a requirement where the customer wanted the difference between 2 values in a table. The challenge here was that because the values are already part of the table, I had to find a way to get the unique value for each item. This…
Power BI RoundUp – Webinar on Advanced Data Prep – Data Flows in Power BI – On-Premise Data Gateway Update – New Power BI Regions in Azure – General Availability of Custom & Certified Data Connectors
Here is my weekly Power BI related round up, I hope that you find this information relevant and keeps you up to date with everything that is happening with regards to Power BI. Power BI – Webinar on Advanced Data Prep with Dataflows https://community.powerbi.com/t5/Webinars-and-Video-Gallery/10-23-18-Webinar-Advanced-data-prep-with-Power-BI-data-flows/m-p/534100 There…
Running Power BI Reports or Dashboards in Fullscreen without the Buttons
I had seen some questions in the Power BI Community when asking how to run reports or dashboards in a browser screen so that they cannot see they buttons on the bottom left hand side. In my example I am going to use my existing…
Quick Tips for Aggregations & Composite Models in Power BI
I have been working with a customer on the implementation of Aggregations with Composite Models in Power BI and I have found that there are a few useful tips to assist you with getting it up and running. Tip 1 – Always ensure that queries…