Power BI blogroll

Jul 07, 2017 - azure.microsoft.com - 0
Super Charge Power BI with Azure Analysis Services

In April we announced the general availability of Azure Analysis Services, which evolved from the proven analytics engine in Microsoft SQL Server Analysis Services. The success of any modern data-driven organization requires that information is available at the fingertips of every business use…

Jul 05, 2017 - sqljason.com - 3
Visio Custom Visual (Preview) for Power BI – Quick Look

A week back, I was at the Data Insights Summit, where I got to hear in person many exciting updates for Power BI. One of the updates was the release of a preview version of a new custom visual – Vi…

Jun 29, 2017 - community.powerbi.com - 8
NBA MVPs Snapshot

Hello everyone,   I used Power BI to give you a 1-Page snapshot of the NBA Most Valuable Players. You can visualise them by Status (Champions), Team, Height & Field Position.   Don't forget to drill-down so you can switch from Team / Position to Player(s) and have a look at the tooltips which often ...

Jun 29, 2017 - blog.revolutionanalytics.com - 5
Interactive R visuals in Power BI

Power BI has long had the capability to include custom R charts in dashboards and reports. But in sharp contrast to standard Power BI visuals, these R charts were static. While R charts would update when the report data was refreshed or filtered, it wasn't possible to interact with an R chart on the screen (to display tool-tips, for example). But in the latest update to Power BI, you can create create R custom visuals that embed interactive R charts, like this: The above chart was created with the plotly package, but you can also use htmlwidgets or any other...

Jun 29, 2017 - azure.microsoft.com - 1
Gain business insights using Power BI reports for Azure Backup

This article talks about preview of Azure Backup Reports using Power BI content pack.

Jun 29, 2017 - dataveld.wordpress.com - 3
10 Ways to Create Maps in Microsoft Power BI

Last year, I wrote a post entitled 5 Ways to Create Maps in Microsoft Power BI. With the introduction of numerous mapping changes in Power BI since then, I felt it best to provide an update as of J…

Jun 29, 2017 - kasperonbi.com - 1
Use the data gateway to connect to SQL Azure databases

One question that comes up  regularly is how to use the firewall option of SQL Azure to open access to just Power BI. Now to use Power BI in general you can use the “enable azure services” option b…

Jun 29, 2017 - datachant.com - 3
Compare Tables in Excel & Power BI - DataChant

Do you often find yourself in dire need to compare two tables in Excel? In today’s blog post, we will create an Excel workbook that compares two tables, and highlights the changes in a third table. You can load new versions of the tables, click Refresh All in Excel, and immediately see the changes in …

Jun 26, 2017 - blogs.office.com - 2
Gain complete insights with the Visio visualizations in Power BI Preview - Office Blogs

Visio and Power BI now work together. With just a few clicks, Visio diagrams become an interactive Power BI visualization to help you drill into specific data points, gain a better understanding of the overall picture and make informed decisions faster.

Jun 26, 2017 - upflow.co - 1
30 Days to Success in Power BI: Day Seventeen Asking Questions

What is Q&A?

It is just what you think it would be: question and answer, only this time your Power BI dashboard end-user asks the question of your data and the software returns an answer!!!! This sounds like some straight-up Skynet Terminators taking over the world science fiction, right? Well, of course, we are data people so now WE HAVE THE ULTIMATE COSMIC POWER!!! OK, maybe not that cool, but still!

Jun 26, 2017 - technet.microsoft.com - 1
Use Power BI with Microsoft Dynamics 365
Jun 26, 2017 - blog.oraylis.de - 1
Local date formats in Power BI | ORAYLIS

In this post a I show a little M function, which you can use in Power BI to transform dates a date format. (yyyy.mm.dd to dd.mm.yyyy)

Jun 26, 2017 - blogs.office.com - 1
Gain complete insights with the Visio visualizations in Power BI Preview - Office Blogs

Visio and Power BI now work together. With just a few clicks, Visio diagrams become an interactive Power BI visualization to help you drill into specific data points, gain a better understanding of the overall picture and make informed decisions faster.

May 31, 2017 - dataveld.wordpress.com - 30
Power BI Analytics Challenge: Part 2 – Processing Data from a PDF

After selecting an initial challenge category for the Power BI Analytics Challenge, it was time to get to work. I chose to visualize data from the American Time Use Survey, which is available from …

May 31, 2017 - sqldusty.com - 31
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. Between Power BI Premium and Power BI Report Server, my head has been sp…

May 31, 2017 - powerpivotpro.com - 11
RANKX-apalooza: Within and Across Groups, With Filters, Etc. - PowerPivotPro

Post by Rob Collie One from the Reference Stacks I sometimes find RANKX() a bit perplexing.  So awhile back I made myself a workbook of examples, whic

May 31, 2017 - blogs.office.com - 3
Announcing the public preview of the Office 365 adoption content pack in Power BI - Office Blogs

Today, we’re pleased to announce the public preview of the Office 365 Adoption Content Pack in Power BI. This toolset enables admins to visualize and analyze their Office 365 usage data, create custom reports, share insights and target training and communications to help drive their organization’s digital transformation.

May 31, 2017 - datachant.com - 14
Row Level Security in Power BI - DataChant

Today we are starting a new series on Power BI Row Level Security (RLS). Implementing RLS in Power BI can be a fascinating topic. Especially when you have design constraints, and cannot rely on a simple logic to apply RLS, or when your IT team cannot support your special security logic with customized AD groups. This is …

May 23, 2017 - sqldusty.com - 16
Setting up the Power BI Report Server Preview

Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power BI Report Server includes the ability to host Power BI reports, along with traditional SQL…

May 22, 2017 - sqlchick.com - 7
Reusing Datasets Imported to the Power BI Service

I'm a big fan of reusing Power BI datasets whenever possible to minimize
redundant datasets floating around the organization. It's less maintenance,
less chance of calculation differences, and less data refreshes to
schedule.

Info verified as of: May 20, 2017

In this post I'm referring t

May 22, 2017 - ruiromanoblog.wordpress.com - 1
Automate Azure Analysis Services Pause/Resume using PowerShell

This is a guest post from my colleague Filipe Sousa from DevScope who will share is very recent findings in automating management tasks in Azure Analysis Services, take it away Filipe: Recently we …

May 12, 2017 - axioworks.com - 7
How To: Import SharePoint libraries into Power BI and create links to the documents | AxioWorks Ltd

How To: Import SharePoint libraries into Power BI and create links to the documents If you have tried to import from SharePoint to power BI you have probably

May 12, 2017 - blogs.adatis.co.uk - 0
Callum | Handling Web Page Errors in Power BI Query Editor

I was recently asked if it was possible to handle Error Rows in the Query Editor and more specifically, to web pages that do not exist from source. The user broached me with this question after following a previous blog on looping through multiple web pages in Query Editor – found here.

May 12, 2017 - blog.crossjoin.co.uk - 17
Power BI Custom Data Connectors

Amid all the other announcements at Microsoft Build today came one I’ve been waiting for a long time: we can now build our own custom data connectors for Power BI. Here’s the...