background preloader

PowerBI

Facebook Twitter

Power BI and SAP – What Works and What Doesn’t – business intelligist. I run many workshops focused on integration of Microsoft Analytics and SAP.

Power BI and SAP – What Works and What Doesn’t – business intelligist

This is not an easy topic to cover due to complexities of the SAP landscape and also because Microsoft Analytics has many moving parts both with respect to its on premise and cloud components. Power BI Architecture Diagram v3 is Now Available! Over the past couple weeks there has been a ton of news and announcements around the direction Microsoft is taking Power BI.

Power BI Architecture Diagram v3 is Now Available!

Create Your Own Custom Map for Power BI - Microsoft Power BI Community. Hi, I’m sharing back with community here (I encourage you to do the same as you come across your own useful Power BI tips and recipes) In this post, I will share how to create a custom map file to use in Power BI.

Create Your Own Custom Map for Power BI - Microsoft Power BI Community

To start out, add a Shape Map visual to a report in Power BI Desktop: Once you add this visual you can pick from lots of included maps as well add your own custom map. That's great, but “Where do I get custom maps or better yet how would I create my own map?” You may ask. Power BI Architecture Diagram v3 is Now Available! GitHub - weiweicui/PowerBI-Routemap. Power BI Report Server. What's new in ArcGIS Maps for Power BI (May 2017) We continue to update Maps for Power BI on a nearly monthly update cycle, and this month we bring interactive drive times, a new tooltip field well, and localized support for many languages.

What's new in ArcGIS Maps for Power BI (May 2017)

Drive time areas When you want to know how many customers / constituents / Power BI data points are within a short drive from your store / polling place / important location, create and use a drive time area. Drive time areas are persisted on the map, so they can be used as a persistent ‘cookie cutter’ to make selections within your current Power BI dataset. Drive time areas pair very nicely with pins, which also persist on the map and can be used to show important locations. Tooltip field well When you want to add more information to the tool tips that appear when you hover over locations, drag fields into the new tooltip field well.

And more! Frequently Asked Questions for Power BI for Germany Cloud customers. The Power BI service has a version available for European Union/European Free Trade Agreement (EU/EFTA) customers, often referred to as Microsoft Cloud Deutschland (MCD).

Frequently Asked Questions for Power BI for Germany Cloud customers

The Power BI service version discussed in this article is specific to EU/EFTA customers, and is separate and different from the commercial version of the Power BI service, or Power BI services provided to government customers. The DAX Unichar() Function And How To Use It In Measures For Data Visualisation – Chris Webb's BI Blog.

A few weeks ago I was asked whether it was possible to display line breaks in text in a Power BI visualisation.

The DAX Unichar() Function And How To Use It In Measures For Data Visualisation – Chris Webb's BI Blog

It turns out it isn’t possible – at the moment Power BI always strips line breaks out of text when it gets loaded into the Data Model. However while researching this I came across the DAX Unichar() function, which returns the unicode character associated with an integer value – and which also seems to be completely undocumented for some reason, I guess because it’s new (it isn’t in Excel 2016 DAX yet as far as I can see). It’s very straightforward to use: for example, the DAX expression UNICHAR(65) returns the character A; see here for a list of unicode characters and their associated codes. Power BI – Free vs Pro Infographic – Gilbert Quevauvilliers – BI blog. I have been active on the Power BI Community Page for quite some time, and what I have often seen is people not quite sure what options are free and what options require a Pro license.

Power BI – Free vs Pro Infographic – Gilbert Quevauvilliers – BI blog

So here is my infographic in which I have put down which options are free and which options will require a Pro license. I am hopeful that people will find this useful in understanding which options are free and which options require a Pro license. If I have left anything out, or something is wrong please let me know and I will update it. Utilising SQL Server Stored Procedures with PowerBI – The CRM Chap. Those who have experience working with an RDMS system like SQL Server will become accustomed towards a certain way of going about things.

Utilising SQL Server Stored Procedures with PowerBI – The CRM Chap

These can often involve a mixture of “lazy” query writing (e.g. using SELECT *… as opposed to SELECT Column1, Column2…), the manner in which you write your query (ALL CAPS or lower case) and best practice approaches. One arguable example of a best practice approach is the use of Stored Procedures. An illustration of how to use a Stored Procedure can most readily demonstrate their benefits. Take a look at the T-SQL query below, which should execute fine against the AdventureWorks2012 sample database: The query returns the data we need, but not in an efficient manner. Implementing a Stored Procedure to encapsulate our query logic immediately addresses the above concerns, by providing us with a single-line query into the database, giving us just the data we need and enables us to utilise the query for other scenarios as well. Tableau and PowerBI compared: which of the leading self-service analytics and data visualisation tools is right for you? Use Regular Expressions in Power BI.

Let Source = Binary.Decompress(Web.Contents(" #"Changed Type" = Table.TransformColumnTypes(#"Imported CSV",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column2", "Column3", "Column4"}), #"Removed Top Rows" = Table.Skip(#"Removed Columns",27), #"Kept First Rows" = Table.FirstN(#"Removed Top Rows",251), #"Trimmed Text" = Table.TransformColumns(#"Kept First Rows",{},Text.Trim), #"Cleaned Text" = Table.TransformColumns(#"Trimmed Text",{},Text.Clean), #"Replaced Value" = Table.ReplaceValue(#"Cleaned Text"," "," ",Replacer.ReplaceText,{"Column1"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value"," "," ",Replacer.ReplaceText,{"Column1"}),

Use Regular Expressions in Power BI

Stories about Enterprise Deployments of the Microsoft Analytics Stack. LinkedIn. Dynamic duration calculation using DAX in Power BI and Power Pivot – The BIccountant. While it is fairly easy to calculate the difference between 2 dates in DAX using DATEDIFF, it is a bit more demanding if you want to exclude weekends and holidays or filter the duration on certain date-intervals, so only get a part of it.

Dynamic duration calculation using DAX in Power BI and Power Pivot – The BIccountant

Also if you want to return on date-time-level instead of only counting net-workdays.This is where this new technique for dynamic duration calculation can come in handy. We can use the basic technique that I’ve described here and modify it by adding 2 columns to the calculated table: Duration per day on a Date-Time-levelMarker-column if weekday or not (this assumes that you have a column in your date-table which indicates if the day shall be considered as weekday or not) The duration-calculation needs to handle the cases where only parts of the day are to be counted: If the event starts and ends at the same day, the difference between those figures has to be taken. Let’s have a final look at our simple measures: Power BI Desktop Dynamic security cheat sheet – Kasper de Jonge Microsoft BI Blog. I recently created this simple Power BI desktop file that allows you to try out dynamic security with the new security relationship feature as described in this blog post.

The model contains the following tables: Sales – contains the metrics, the fact tableGroup – is the dimension table that groups a set of users. This can be anything in the real world, a department, a geography, productgroup, etcUser – the users with their username connecting to the reportsUserGroup – This ties individual users to the “group”, this usually is a M:M relationship where many users belong to multiple groups. All relationships are set to single directional filtering except the one between Group and UserGroup. This allows the filter from the User table to filter the groups down to only those groups where the current user has access to, in turn filtering out the rows in the sales table for just those groups Hope this helps you get start started faster with dynamic RLS.

Use SQL Server RLS with SSAS and Power BI – Kasper de Jonge Microsoft BI Blog. One of the questions I get regularly now that SQL Server supports RLS is how can to leverage this with SSAS. What many don’t know is that SSAS already supports this, even for Direct Query mode. So in this case you could have something like the following architecture: Dashboards and reports in Power BI that connect to an on premise SSAS server running DirectQuery mode connecting to SQL Server. On-premises data gateway. The on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI, Microsoft Flow, Logic Apps, and PowerApps services.

You can use a single gateway with different services at the same time. If you are using Power BI, as well as PowerApps, a single gateway and be used for both. It is dependent on the account you sign in with. Requirements Minimum Requirements: .NET 4.5 Framework 64-bit version of Windows 7 / Windows Server 2008 R2 (or later) Recommended: 8 Core CPU 8 GB Memory 64-bit version of Windows 2012 R2 (or later) Related Considerations: The gateway cannot be installed on a domain controller You shouldn't install a gateway on a computer, such a laptop, that may be turned off, asleep, or not connected to the Internet because the gateway can't run under any of those circumstances. Making It Easier To Administer Power BI. The Power BI Admin Portal gives organizations the ability to view usage data and set controls and limits on how Power BI is used throughout the organization.

We have heard from many administrators that these capabilities are critical, but sometimes getting the right person access to the Portal was hard because it was only available to Office 365 Global Administrators. Introducing the Power BI Service Administrator Role Today we’re introducing the new Power BI Service Administrator role, which can be assigned to users who should have access to the Power BI Admin Portal without also granting them other Office 365 administrative access. Add-MsolRoleMember -RoleMemberEmailAddress "tim@contoso.com" -RoleName "Power BI Service Administrator" If you’re not a PowerShell user, the capability to assign the Power BI Service Administrator role will be coming to the Office 365 Admin Center by the end of the year. Easier for Cloud Solutions Providers too. Free ebook: Introducing Microsoft Power BI – Microsoft Press blog.

The "only" Power BI calendar you will ever need - oxcrx34285. Use inline hierarchy labels in Power BI Desktop. Power BI Desktop supports the use of inline hierarchy labels, which is the first of two features intended to enhance hierarchical drilling. How to Define a Measure Table in Power BI Desktop.