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…
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…
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…
Power BI – (March Desktop Update, Theme’s Generator, Esri New Technology Integration Award, K2 Process Content Pack, Advanced Search Solution Template, Project Service Automation for Dynamics 365 Solution Template, New Custom Visual 3D Pie Chart)
There has been a whole host of updates to Power BI in the past week which is great to see, so I hope that you enjoy reading this as much as I enjoyed putting it all together. Power BI – March Desktop Update In this month’s updates there are a whole host of great updates, and the Power BI Team…
Power BI – Power Query/Query Editor Automated Source Control
I saw a blog post recently where Jay Killeen was talking about how he handles his Source Control for the Query Editor or Power Query. And this got me thinking of how I could automate this in a quick and easy manner. So below is how I achieved this. My solution below, uses a BAT file and 7zip, which means…