Power BI blogroll

Apr 25, 2017 - thebiccountant.com - 6
Power BI and SQL Server BI blog posts | KPIs in Easy Profit and Loss for PowerBI – The BIccountant

KPI for easy Profit and Loss in PowerBI as the last part of my series: Learn how to write them for columns and rows with minimal efford.

Apr 24, 2017 - eriksvensen.wordpress.com - 35
Power BI and SQL Server BI blog posts | Set size for multiple visualizations in #PowerBI at the same time

When designing your reports in Power BI Desktop you properly spent a lot of time making sure your visualizations is aligned and at least for some of them making sure they have the same size. So far…

Apr 21, 2017 - linkedin.com - 28
Power BI and SQL Server BI blog posts | Want a data driven culture? Why Power BI should be your tool of choice

The data driven culture buzzwords have been around for years, but has it REALLY happened anywhere?? For years I've heard and listened to all the

Apr 20, 2017 - linkedin.com - 14
Power BI and SQL Server BI blog posts | How to... CSVs to BI Dashboard in 10 minutes!

If you've ever clicked 'Export to CSV' then we are kindred spirits. In a previous life as analyst and accountant, I have been an unwilling follower of

Apr 18, 2017 - blog.crossjoin.co.uk - 7
Power BI and SQL Server BI blog posts | Power BI, SSAS Multidimensional And Dynamic Format Strings

If you’re building reports in Power BI against SSAS Multidimensional cubes then you may have encountered situations where the formatting on your measures disappears. For example, take a very simple…

Apr 18, 2017 - businessintelligist.com - 22
Power BI and SQL Server BI blog posts | Embedding PowerApps in Power BI Dashboards

It’s no secret that PowerApps and Power BI are related or so you might think considering that both products have the word “power” in their names. Although Microsoft is yet to offi…

Apr 13, 2017 - linkedin.com - 16
Power BI and SQL Server BI blog posts | ArcGIS Map in Power BI; Insightful

I have written about 4 other types of map visual with Power BI before. In this post I want to explain how ArcGIS visual work as a map visual. There

Apr 13, 2017 - powerbi.microsoft.com - 6
Power BI and SQL Server BI blog posts | Analyzing United States County Data Trends with SandDance for Data Storytelling | Microsoft Power BI Blog | Microsoft...

What do you get when you combine a passion for data and Microsoft Power BI with an interest in U.S. politics, social economic and cultural trends? You receive compelling reports covering election data, obesity and drug overdose rates, along with income per capita levels within the United States over the past 10+ years. See how Microsoft Program Manager Jeff Lumpkin uses the SandDance custom visual to create rich modeling, interactivity, and animated transitions to aid in data storytelling.

Apr 13, 2017 - yanaberkovich.com - 7
Power BI and SQL Server BI blog posts | Connecting PowerBI Desktop to Oracle? | YanaBerkovich
Apr 13, 2017 - blogs.partner.microsoft.com - 8
Power BI and SQL Server BI blog posts | Use Power BI to Help Manage Your SharePoint Sites - Microsoft Partner Network

  When it comes to Business Intelligence, SharePoint is most often used as a platform to access dashboards and reports. With the recent availability of the Power BI web part, Power BI joins SQL Server Reporting Services and Excel as a go-to reporting tool within SharePoint. Occasionally, list data is used as a data source … Continue reading Use Power BI to Help Manage Your SharePoint Sites

Apr 12, 2017 - blog.crossjoin.co.uk - 1
Power BI and SQL Server BI blog posts | The DAX Unichar() Function And How To Use It In Measures For Data Visualisation

A few weeks ago I was asked whether it was possible to display line breaks in text in a Power BI visualisation. It turns out it isn’t possible – at the moment Power BI always strips line breaks out…

Apr 12, 2017 - sqlkover.com - 14
Power BI and SQL Server BI blog posts | Calculate a semi-additive average in DAX

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it's the time dimension that isn't additive. For example, the stock level at various warehouses. You can add

Apr 10, 2017 - blue-granite.com - 12
Power BI and SQL Server BI blog posts | Tracking Adoption via Power BI Audit Logs

A common approach to assess ROI on any BI tool deployment is through adoption metrics. Check out this example to see how you can track your adoption rates!

Apr 10, 2017 - sqlserverbi.blog - 14
Power BI and SQL Server BI blog posts | Power BI Quick Measures is a Game Changer

Every few months a feature is added to Power BI that gets my attention and really seems to make  difference.  Quick Measures is one such feature that has my attention.  As a long-tim…

Apr 10, 2017 - radacad.com - 9
Power BI and SQL Server BI blog posts | One Data Set, Multiple Reports; Power BI Next Big Step Forward | RADACAD

You can use an existing data set with LiveQuery or DirectQuery connection as the shared data source for multiple Power BI reports. You can also create multiple reports from Power BI Service (website) connecting to the same data set. However, this new feature in Power BI Desktop version April 2017 is a big step forward; You can now create reports in Power BI Desktop pointing to a central data set

Apr 10, 2017 - venkatrao.co - 4
Power BI and SQL Server BI blog posts | Embed Power BI Dashboards in CRM For Dynamics 365 With Just One Click - Venkat Rao

Just this one setting in System Settings under the 'Reporting' tab will enable Power BI dashboards in CRM for Dynamics 365.

Apr 03, 2017 - sqlshack.com - 3
Power BI and SQL Server BI blog posts | How to optimize the dimension security performance using partitioning in SSAS Multidimensional

Introduction In the articles How to partition an SSAS Cube in Analysis Services Multidimensional and Benefits of Partitioning an SSAS Multidimensional Cube, the concept of measure group partitioning is introduced and the advantages are clearly illustrated. One of the biggest advantages of partitioning is partition elimination, where only the partitions necessary to satisfy the query …

Apr 03, 2017 - datachant.com - 22
Power BI and SQL Server BI blog posts | Web Scraping in Power BI and Excel Power Query - DataChant

Follow Me There are abundant public data sources on the Web, and it is so tempting to import and mash them up with your existing data sets in Power BI and Excel Power Query to gain new correlations and insights. While it’s easy to import static tables from many websites in Power BI and Excel Power Query, …

Apr 03, 2017 - blogs.msdn.microsoft.com - 12
Power BI and SQL Server BI blog posts | Power BI – Using the Treemap Visual with KPI status colors (red, yellow, green)

Using the Treemap Visual with KPI status colors (red, yellow, green) “Is possible to modify the default colors of the Treemap visual to reflect red/yellow/green status based upon a status field value?” This question was asked yesterday in a customer demo, and I didn’t know the answer off the top of my head. As it...

Apr 03, 2017 - linkedin.com - 12
Power BI and SQL Server BI blog posts | Power Query - solving all sorts of Excel issues

Some may see Power Query simply as a brilliant way of connecting to multiple data sources and loading that data into a Microsoft Power BI development

Mar 31, 2017 - community.powerbi.com - 14
Power BI and SQL Server BI blog posts | A simple and fun guide to Microsoft Flow and Power BI

In Sweden there is a company called Hemglass that delivers ice cream to people’s homes in refrigerated vans. This company is very well know in Sweden, not only for its ice creams, but also for the music the van’s play to alert people they have arrived at their door. If you are curious about how it s...

Mar 31, 2017 - mssqltips.com - 5
Power BI and SQL Server BI blog posts | Bi-Directional Cross-Filtering in Analysis Services Tabular 2016 - Part 1

Learn how the new bi-directional cross-filtering feature of Analysis Services Tabular 2016 has simplified the set-up for many-to-many relationships.

Mar 29, 2017 - linkedin.com - 21
Power BI and SQL Server BI blog posts | I'm Climbing the DAX Wall

Introduction Although I have been using DAX productively for a while now I have still not evolved from being uneasy with it - it still feels a bit

Mar 28, 2017 - businessintelligist.com - 22
Power BI and SQL Server BI blog posts | Market Basket Analysis using Power BI

  It’s been almost two years since I posted about the CONCATENATEX() DAX function here. At the end of that post I promised to publish a tutorial on how one might do Market Basket analysi…

Mar 28, 2017 - gqbi.wordpress.com - 21
Power BI and SQL Server BI blog posts | Power BI – Create Last Dataset Refresh Date

Whilst I have read and found other ways to get the Last Dataset Refresh Date, I find that my method is a lot easier and cleaner to complete. Creating the Last Dataset Refresh Data Open Power BI Des…