BI-RoundUp – Power BI (Desktop Update for June, Service Updates for June, Dashboard Email Subscriptions) – Excel (Get & Transform Updates June 2017)
Here is my weekly BI-RoundUp with what has happened and what is new. Power BI – Desktop for June Finally the Power BI Desktop July update is here. So here are the details below of the new updates. Reporting The table and matrix visuals are now generally available. Not only that but they have also made some additional enhancements which…
Data Insights Summit Details – Day 1 Summary
With the Microsoft Data Insights Summit that is currently happening in Seattle the Power BI team has been really busy letting us know what features are coming and what to get excited about in the coming months, so below is a quick overview of what has been released after Day 1.
BI-RoundUp – Power BI (Office 365 Adoption Content Pack – Embedded Accelerator) – Excel (Get & Transform Updates May 2017)
This will no doubt be a quieter week, leading up towards the end of May and into June when there will be the next wave of updates from the Microsoft Power BI Team You might also notice that I have changed the name from BI-NSIGHT to BI-Roundup, as there was another blogger who has his blog URL as BiInsights, so…
Power BI – Free vs Pro Infographic
I have been active on the Power BI Community Page for quite some time, and what I have often seen is people not quite sure what options are free and what options require a Pro license. So here is my infographic in which I have put down which options are free and which options will require a Pro license. I…
Power Query – Adding Parameters within a piece of text
Below is where I had a situation where I wanted to put in a parameter within a piece of text. This was so that I could then dynamically change the Month Version for my budget and when I refreshed my data it would then use my specific Month Version. This was due to the requirement being that they wanted the ability to…
BI-NSIGHT – Power BI (Microsoft Flow & Power BI, Webinar How Microsoft Handles Power BI)
I have no doubt that as the year moves closer to the end of the year there will be slightly less news and updates. But with that being said here are this weeks updates. Power BI – Microsoft Flow and Power BI I have been personally looking at Microsoft Flow lately and it can really automate many tasks, as well…
Power BI Quick Tip – Using Parameters in Power Query Filters
I have been working lately quite a bit in Power Query and having to shape and re-create data based on the requirements. They had a requirement to make the data dynamic and immediately the Parameters in Power BI came to mind to create the solution. Now as we know using Parameters in Power BI has a lot of advantages. But one quick…
Power BI Service – How to disable Analyze in Excel (Disable Users from Downloading any data from Power BI)
I was recently looking how to help out in the Power BI Community where there was a question around how to disable users from having the ability to disable Analyze in Excel in the Power BI Service. This could be a very valid situation where you do not want users the ability to export or download any data from the…
BI-NSIGHT – Power BI (Mobile Apps Update, Custom Visual Tool Development Update, Dynamic Security Cheat Sheet, JavaScript API, Infer Content Pack) – Microsoft Flow (Available to Everyone) – SQL Server Analysis Services 2016 (Tabular Editor)
Another great week in the world of BI. Power BI – Mobile Apps Update for August 2016 Another month goes by and some more updates, this time from the Mobile Apps team. In this update they have done quite a lot of work with regards to the ability to do manual refreshing of your data in iOS if you have…
Create Dynamic Periods for Fiscal or Calendar Dates in Power BI
I came across Chris Webb’s excellent post (Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M) in which he demonstrated how to leverage the Bi-Directional filtering in Power BI. Chris goes into great detail to explain how he goes about creating the functions, tables and how it all pieces together. This got me…