BI-NSIGHT – Power BI (Service March Update – New Navigation Experience, Desktop Terms & Definitions – Whitepapers) – BI Survey (BARC BI Survey 2017) – Excel – (Get & Transform Updates for April 2017)
There has been a variety of updates and blog posts in the past week, so here are my BI updates. Power BI – Service March Update There were quite a few service updates for March within the Power BI Service. The first was the granular controls which was a very welcome feature. And I know that something that a lot…
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…
BI-NSIGHT – Power BI (Desktop Update April – Quick Measures Preview – Mobile Apps Summary – Video Gallery & Ask a Partner Anything – View Related Content Pane – Sneak Peak add new Columns from Example – Tracking Adoption via Power BI Audit Logs)
There has been a whole host of updates and interesting things in Business Intelligence in the past weeks, so please find below the updates. Power BI – Desktop Update April This month’s Power BI Desktop update for April has a whole host of great updates and new features this month, which I will highlight what I think is most relevant…
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…
Power BI – Create Last Dataset Refresh Date
Whilst I have read and found other ways to get the Last Dataset Refresh Date, I find that my method is a lot easier and cleaner to complete. Creating the Last Dataset Refresh Data Open Power BI Desktop and go into the Query Editor. Then click on New Source and select Blank Query Next I renamed my Blank Query from…
BI-NSIGHT – Power BI (Design your own Swag, Custom Refresh Schedules for Live/DirectQuery, Report Theme Gallery, Custom Visuals Community Site, Filter a report with a URL query string, Summit EMEA, Custom Visuals in Office Store, Data Insights Summit Session Details
Once again the world of BI is very busy with great new features and other details which I have put into this blog post below. Power BI – Design your own Swag There is a competition to design your own Swag Shirt for Power BI. As you can see above is my entry, so if you like it, please go…
BI-NSIGHT – Power BI (Custom Refresh Schedules for Live/DirectQuery, Report Theme Gallery, Custom Visuals Community Site, Filter a report with a URL query string, Summit EMEA)
Once again the world of BI is very busy with great new features and other details which I have put into this blog post below. Power BI – Custom Refresh Schedules for Live/DirectQuery I have to say I have noticed that the Power BI team are currently releasing a lot of features which give a lot more granular control to…
Power BI – Gateway Infographic
Following on from my previous Power BI Infographic blog post, I also have had the idea to create an Infographic for the Power BI Gateway. This came about after reading the blog post by Kasper De Jonge Enterprise gateway sizing “recommendations”, and there was a lot of valuable information which I have put into the Infographic as well as detailed…
BI-NSIGHT – Power BI (Granular Tenant settings, Amazon Redshift connectivity in Power BI Service, Featured Data Stories, Availability Monitoring Publish to Web) – Excel (Get & Transform updates) – SQL Server (DAX support in Report Builder and SSMS)
Here are the weekly updates. Power BI – Granular Tenant Settings I can personally say that I know a few of my clients who are very happy that the Power BI team has already implemented the Granular Tenant settings for Power BI. I have to say that I am once again impressed by the Power BI Team really a great…
Power BI Query Editor – Getting IP Address Details from IP Address
I recently had a question from a user in the Power BI Community page who wanted to know where the people were coming from based on their IP Address. The IP addresses were stored as part of the dataset, but to try and go and do this with the IP Address database meant that you would then need to go and…