BI-NSIGHT – Power BI (Data Insights Summit 2017, Integrate Reports into SharePoint, Dual KPI, Featured Data Stories, Apply Filters to your report per User, Grid Custom Visual)
There have been some really great updates coming out especially from the Power BI team in the past week. So let’s get into it. Power BI – Data Insights Summit 2017 I can remember that the Data Insights Summit of 2016 was a great success and heard some great content and really deep dive information was shared at the summit….
Power BI – Getting your report to always filter this month’s data dynamically
I had a requirement where I needed to have the capability to set the filter once on a report for the current month and then it dynamically move as each month progresses. I will show how I completed this in the steps below. NOTE: As with almost all Power BI Models, this is going to be leveraging off my Date table…
BI-NSIGHT – Power BI (February Desktop Update, iOS Mobile App with Q&A, Dual KPI Custom Visual, PowerApps Common Data Service) – Excel (Get & Transform Updates for January)
I had to re-write this, as I had a suspicion that the Power BI Desktop would be released soon and here it is, along with other updates. Power BI – February Desktop Update This Power BI Desktop update is here, and I have to say that there are some awesome additions and new improvements. So I will highlight below what…
Power BI – Why creating columns in the Query Editor is better, quicker and more efficient than creating Calculated Columns.
I have been reading and helping out where I can on the Power BI Community forums. And what I often see is people trying to use the Calculated Columns in the Power BI Desktop Model. So in this blog post below I am going to explain why it is better, quicker and more efficient to use the Query Editor to create additional columns….
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 – Quick Tips working with multiple large CSV Files
I have recently been working a lot with multiple larger type CSV files, and thought it would be good to share what I have found that makes the process run faster. I am always looking at ways to make sure that not only is the model efficient, but also the development experience. Name your query first before applying steps in…
Power BI – How to Easily Create Dynamic Date Table/Dimension with Fiscal Attributes using Power Query
I have been working on some new projects and one of the things that I found that was whilst you can find examples of creating Date tables, I could not find any examples of where the Date table included Fiscal Attributes such as Fiscal Month, Fiscal Quarter and Fiscal Year. So in this blog post I am going to show…
BI-NSIGHT – Power BI (Desktop Update – May, New Visuals, Gateway Enterprise Update, Azure ML Predictions, Planned Work started) – SQL Server 2016 (Generally Available, Mobile Report Publisher,SSMS
Here are the weekly BI Updates, with a lot of great things within Power BI as well as the major release for SQL Server 2016 Power BI – Desktop Update for May Well this week there is a whole stack of updates to the Power BI Desktop which once again is great to see so many updates and actual user…
BI-NSIGHT – Power BI (May Service Update, Q&A for Enterprise Gateway, Solution Templates, UserName() in Power BI, Local Excel Files Upload, Download Dashboards / Reports to .pbix file, Forecasting Feature, Webinar Intro to Power BI for the Excel User – Newsletter
Here are this weeks updates Power BI – May Service Update There is a whole host of updates to the Power BI Service this week, and some great additions. The first improvement is the increasing in the file size to 1GB. And whilst we all know that the compression is really good with Power BI and Power Pivot, there are…
BI-NSIGHT – Power BI (Service Update, Desktop Update, Dynamic Security in Service, Content Pack Dynamics AX Cost Management Pack) – SQL Server 2016 (RTM Release 01 June 2016)
There has been another busy week in the world of BI, here are the details. Power BI – Service Update for Drilling into Data It appears that the features that have put as part of the Power BI Desktop update are now also in the Power BI Service. This is great and I have no doubt that further details will…