BI-NSIGHT – Power BI (Power BI Reports on SSRS, Custom Visual Infographic Designer, Power BI Service Admin Role, MYOB Content Pack, Checking for Issues with Power BI Service) – Azure (Analysis Services – SSAS)
I have no doubt that by the end of this week there is going to be quite a lot of content with regards to the world of Power BI. And that is all thanks to PASS, which I am sure I will attend in the near future. So lets see what we have in store. Power BI – Power BI…
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…
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 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…
BI-NSIGHT – Power BI (Featured Data Stories, Dashboard Makeover, Office 365 Adoption Content Pack, JIRA Content Pack) – Excel (Get & Transform Update)
Here are this week’s BI-NIGHTS updates. Power BI – Featured Data Stories There are some great data stories featured in the Power BI Data Stories showcase. I have to have a special mention to myself that I managed to get my Create Dynamic Periods for Fiscal or Calendar Dates and Dynamic Month Names for Charts also featured which I am…
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 (What’s coming to Power BI, September Desktop Update, Mobile App Update, Community Blog Highlights, How to Optimize your mobile phone experience, Installing Power BI Desktop through SCCM, Changes to Support, Help Improve Power BI Survey
With Microsoft Ignite completed I have no doubt that we very soon will see some of the announcements starting to be seen in the Microsoft products. So here are this week’s updates. Power BI – What’s coming to Power BI As you can see from the image above there is a lot of things coming to Power BI in Fall…
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…
BI-NSIGHT – Power BI (ArcGIS Maps, Forthcoming updates, Intune MAM for iOS App, Creating Custom Visual, Narrative Science) – SQL Server 2016 (CU Update 2, Embed Paginated Reports into ASP.NET)
This is going to be a rather long or large blog post with Microsoft Ignite this week I am certain that there will be some really amazing announcements. So here we go.. Power BI – ArcGIS Maps I am really looking forward to being able to use ArcGIS maps in Power BI. And not only will this be included in…
BI-NSIGHT – Power BI (August Power BI Desktop Update, Future Download Report & Snap to Grid, IntelliSense coming to Power Query, Power BI Training, WebTuna Content Pack, Building a Real-Time IoT Dashboard, Chris Webb Loading Data from Multiple Excel Workbooks saved in OneDrive, SCCM Solution Template) – SQL Server (SSAS Integrated Workspace Mode, SSMS Update, Report Builder Update)
Last week there was not a lot on the go, but it seems to have picked up this week, so here are the latest insights. Power BI – August Power BI Desktop Update As I am sure some of you would have already seen and heard and I personally have to echo what other people have said, it is great…