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…
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 (Mobile Apps Update, Custom Visual Tool Development Update, Dynamic Security Cheat Sheet, JavaScript API, Infer Content Pack) – Microsoft Flow (Available to Everyone) – SQL Server Analysis Services 2016 (Tabular Editor)
Another great week in the world of BI. Power BI – Mobile Apps Update for August 2016 Another month goes by and some more updates, this time from the Mobile Apps team. In this update they have done quite a lot of work with regards to the ability to do manual refreshing of your data in iOS if you have…
Create Dynamic Periods for Fiscal or Calendar Dates in Power BI
I came across Chris Webb’s excellent post (Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M) in which he demonstrated how to leverage the Bi-Directional filtering in Power BI. Chris goes into great detail to explain how he goes about creating the functions, tables and how it all pieces together. This got me…
BI-NSIGHT – Power BI (Secure and Audit Power BI, Data Driven Parameters, Snowflake Data Connector) – Excel (Get & Transform Updates / Power Query Updates)
Here are the BI updates for this week. Power BI – Secure and Audit Power BI One of the questions that is regularly asked with regards to Power BI is around how secure the data is. And along with that is how do people gain access. This new update goes a long way not only to make Power BI more…
BI-NSIGHT – Power BI (Desktop Update for August, R Showcase, Content Pack Certification Program Overview, Power BI Publisher for Excel Update) – OkViz (Sparkline Visual)
Here is another week of BI news and information. Power BI – Desktop Update for August This month there is another great list of updates in Power BI Desktop. As I have done previously I will highlight what I personally think are great updates. Report View Updates There have been quite a few updates in the report view. The ability…
Power BI – Creating Dashboard Items that show MTD (Month to Date), or WTD (Week to Date), or YTD (Year to Date) dynamically changing based on your current period
I have been working quite a lot with Power BI, and one of the great features is Q&A So what if you wanted to create a dashboard item that would always show you your sales for the current month (MTD), or current week (WTD) or current Year (YTD)? And always show the correct current period, without you having to go…
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…