Power BI

SQL 16 SSRS on Power BI app for iOS http://blogs.msdn.com/b/powerbi/archive/2015/12/30/sql-16-ssrs-on-power-bi-app-for-ios.aspx

PASS SQL Saturday #460 Slovenia 2015 Recapitulation http://sqlblog.com/blogs/dejan_sarka/archive/2015/12/30/pass-sql-saturday-460-slovenia-2015-recapitulation.aspx

Power BI and R – Part 1 (Intro) http://blog.janmulkens.be/power-bi-and-r-part-1-intro/

The coming year is going to be a big one for customers of Microsoft's on-premises and/or cloud-integration technologies. Microsoft officials recently made available for download a roadmap for its various integration products, which include its BizTalk application-integration server, as well as its Azure Stack and Logic Apps technologies that are part of its Azure App Service offering.

Top Categories Machine Learning R Programming

Power BI Enterprise Gateway (Preview), Everything You Need to Know – Episode 1 http://biinsight.com/power-bi-enterprise-gateway-preview-episode-1/

Running a blog on your business website enables you to attract customers that are searching for information related to your business and helps you connect with them. But, do you know how your blog

Use R to export data from Power BI (and Power Query) http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

It’s finally here – Microsoft SQL Server 2016 CTP 3.2, and with it, the introduction of Mobile Reports and KPI’s into SQL Server Reporting Services.  These new capabilities are based on Datazen tec…

I have to admit that I couldn’t resist to “recycle” my example from here to create the same (almost the same) Data Visualization in combination with Power BI. You can find the Pow…

This measure allows you to predict dependent values Y from independent values X. NAME: Simple linear regression DESCRIPTION: Estimate Y values based on X values. PARAMETERS: Name: Category Tooltip: The category for which you have known X and Y values Type: Categorical field Name: Measure X T...

This month we are very excited to share one of our most anticipated features from the Microsoft Data Insights Summit: Bookmarking. Combining bookmarking with some of our other recently released features such as drillthrough and what if gives you powerful storytelling capabilities and lets you create highly interactive reports. We also have some more visual improvements and a big update to our quick measures feature this month.

Until recently, the only way to install Power BI Desktop was to download and install the .exe installer from powerbi.com. Which was an easy way of a next – next – next setup approach. B…

The Man, The Myth, The On-Prem Server Guy… Chris Finlan and I have known each other for some time now. He emailed me out of the blue 3.5 years ago and we’v

Push data to Power BI dataset, for visualization on realtime dashboards

One of the common questions I get in live courses, blog comments and forum posts is a variant of, “How do I format my data in Power Query or Power BI?” The short answer is that you don’t, but the … Continue reading →

This is best shown with an image of my completed Power BI Desktop file. The data below is from Gap Minder in which it shows how many hours people work by country over time. What I wanted to do was to compare based on Australia which countries work more and which countries work less. As you can se...

Microsoft Senior Program Manager Christian Berg is back with another entry in his series on becoming your organization's strategic advisor with Machine Learning and Power BI. In part 6, he lookd at connecting to an Azure ML Studio experiment with an Rviz and then building on that to create a dynamic report to explore cross price elasticities. He also looks at a simpler example where we instead use DAX to explore the impact of different discount percentages, based on an assumption about our elasticity.

Case Do you also regularly get the question from customers about which data the chart shows and what...

Charles Darwin circumnavigated the globe with Captain Robert Fitzroy between 1831 to 1836. He is most famous for he theories on evolution, which were very much informed by this journey. This Power BI report is an attempt to tell the story of this voyage and some of his discoveries along the way. ...

A common questions I get is to change the connection string to from my report to SSAS after I move my Power BI desktop file into SSAS. It turns out this actually pretty simple as there is an API th…

In the latest update of Power BI Desktop, there now is the capability to be able to use Bookmarks. What bookmarks does is allow you to create an informative way in which you can tell your story. It…

In the last posts (Series of Time Series), I have explained about what is ARIMA, what is d,p, and q in ARIMA (p,d,q). In this post, I will talk about how to use ARIMA for forecasting and how to handle…