BI-NSIGHT – Power BI (SSRS mid 2017, Mobile Apps Update, OkViz Custom Visuals Updates) – SQL Server vNext (Get Data Experience,
Whilst last week there was not a lot of news in BI, Microsoft has been releasing some information which does make it feel like Christmas in the area of BI! Power BI – SSRS Mid 2017 This was really some welcome news especially for the people who use SQL Server Reporting Services (SSRS) and are looking to use the Power…
Power BI (DAX) – Quick Tip – How to count how many items are selected on a Slicer
Update: 16 December 2016 (I got a comment from Marco Russo, who suggested that can use the FILTERS DAX Syntax which will “Return a table of the filter values applied directly to the specified column.” As well as this should also be faster. I am all about the speed! I was working on a Power BI Project and one of…
BI-NSIGHT – Power BI (Mobile App Update – Android Tablets, Navigation Preview, AMA, Driving Power BI Adoption in your Organisation) – Excel (Get & Transform Update)
It does appear that as we approach the festive season, the Microsoft team are still full steam ahead, which is great for myself and the Data Analytics community. Power BI – Mobile App update for Android Tablets As per their blog post, it is great to see that there now is an App for the Android tablets, whilst this has…
Power BI – Using Parameters in Calculated Measures (Making Calculated Measures Dynamic based on Parameter)
What this is going to explain below is how I use a parameter that a user has entered to make a Dynamic Calculated Measure based on the Parameter entered. Example Scenario In my model I have got Parameters for the Fiscal Start Year So I want to create a calculated Measure that will get me the values for 4th Year…
BI-NIGHT – Power BI (Export to PowerPoint, New Visual Liquid Fill Gauge, Tech Tip Display Text, Automating Power BI Desktop Refresh, Webinar Create PowerApps to send real time data to Power BI) – DAX Studio (Release 2.5.0)
Another week closer to SQL Pass, and here are the recent updates and interesting articles Power BI – Export to PowerPoint It is great to see that after some screenshots from Microsoft Ignite that this has already been implemented into the Power BI Service. I am sure that there will be more details around this in due course from the…
Power BI – Dynamic Row Level Security – Things you need to know to get it working!
Below I am going to explain some of the caveats that you need to be aware of when implementing Dynamic Row Level Security (RLS) in Power BI. Without this I could not get Dynamic RLS security working for me and my data. I found that there are a few things that are currently not mentioned anywhere and it took me…
Power BI – (Twitter Solution Template, Real-time Data, Embedded GA Pricing Update, On-Premise Data Gateway Update, Monitor On-Premise Gateway) – SQL Server 2016 (SSDT Update, SSMS Update)
Here is this week’s BI updates Power BI – Twitter Solution Template This is the second solution template offered by the Power BI team and this time I think they have done a fantastic job. As I know of many companies who are active on Twitter and currently either do not have the resources or the time to be able…
BI-NSIGHT – Power BI (Upcoming Updates, Forecasting in Power BI, Q&A Updates, Row Level Security, Excel in Power BI, Cortana Integration, New Visuals, Power BI App on Apple Watch, Desktop Trend Lines, Desktop Drill Through, Desktop Conditional Formatting, Power Apps) – SQL 2016 – Part 2
Well with the Microsoft Data Insights Summit I was under no illusion that there was going to be a whole host of updates and great new features to Power BI. And it was great to see that I was not disappointed. So here are the highlights that I thought would be great to mention for this week’s blog post. Here…
BI-NSIGHT – Power BI Desktop (Monthly & Service Update) – Excel 2016 (Add-In for Machine Learning) – Power BI (Sankey Visual, Power BI Community, Office365Mon Content Pack)
As this year begins to really wind down it is good to see that the Microsoft machine also appears to be having a break. I have no doubt that in 2016 it will be full steam ahead and back into the swing of things. And before I could finish this blog post I checked if there was any news and…
BI-NSIGHT – Power BI Desktop (Date Hierarchy) – Power BI(Timeline Slicer Visual, Pin Excel Range to Dashboard, Power BI User Groups, Weekly Service Update, Visual Studio Application Insights Content Pack) – Microsoft BI Reporting Road Map – SQL Server 2016 SSIS Updates
With the Pass conference completed last week there has been a lot of information about SQL Server 2016 and the future does indeed look bright for BI within the Microsoft BI stack. And I personally think that in the future they will be leading in most of the BI areas. I am not going to go into all the details…