service

With the February Power BI Desktop and a recent companion Service update, you now have the option to add a customized collection of visuals for users. Companies may easily distribute their own or t…

The Power BI service and mobile team is thrilled to kick off the first feature summary blog for 2018! With a new year in full swing, we’ve been hard at work on features to make it easier for you to…

Announcing Visual Studio Team Services (VSTS) Solution Template Blue Margin, Inc., Microsoft Gold Partner in Data Analytics and Data Platform just released a VSTS solution template to provide project…

This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the lat

The Power BI Service (PBIS) is designed to make your life easier. Save your file locally, let it sync to SharePoint Online, track versions, and publish the app after the report is refreshed.

Power BI Report Server is an on-premises product based on the SQL Server Reporting Services (SSRS) framework which allows hosting, sharing, and collaborating on Power BI Reports, all behind your organization’s firewall.

In some cases, you might not want to give all users access to all measures in your model – you might not want to show the profit to certain users. In the Power BI Desktop designer/Service we can…

When purchasing Power BI Premium, you get the best of both worlds when it comes to reporting – Power BI Service and Power BI Report Server. Power BI Service gives you all the functionality of Power BI and cloud reporting while Report Server allows you to continue to host reports behind your firewall

After getting back from the MVP Summit in Bellevue, which was an incredible experience the Power BI team has been extremely busy getting some great new features out the door. Which means there is q…

Last week I got involved with a customer issue. A refresh of the data imported to a PBIX always works in Power BI Desktop, but the refresh operation intermittently fails in the Power BI Service. Their workaround had been to refresh the PBIX in Desktop and re-upload the file to the Service. This post

It’s time again to recap all the features and announcements in Power BI service and mobile in the month of February. Here’s what we released: Automatically install apps, P4 and P5 capacities on Premium…

The feature you have all been waiting for is finally here. Today, I’m thrilled to announce the general availability of persistent filters in the Power BI service. All Power BI reports will now…

The other day, one of my enterprise customers asked me if there were any guides or documentation to forecast the cost for Power BI service licensing (Pro and Premium) for 3 years based on user grow…

Power BI Service and Mobile February Feature Summary Announcing Persistent Filters in the Power BI Service Share your Power BI content with anyone by email Power BI Desktop March Feature Summary Power BI for Mixed Reality app now available in Preview BONUS ITEMS: BI Bake Off at Gartner Data and Analytics Summit 2018 On-premises data […]

New capability reduces the time, complexity and cost of extracting intelligence from disparate data sources.

There have been a lot of important Power Apps and Flow announcements today, as well as the announcement about the Common Data Service for Analytics which is undoubtedly massive news for Power BI us…

The Power BI Rebind API allows you to change the dataset of a report. Patrick shows how you can use the Power BI Rebind API to move from a cached dataset to a live connection on Azure Analysis Services. PowerShell examples

After last week, it appears that the Power BI team is still very busy, and after the announcement yesterday and the download of the Spring Roadmap there is a whole host of amazing things coming in …

Tour of the Power BI Solution Advisor (@paul_turley) Capturing Power BI queries using DAX Studio (@marcorus) Improving The Performance Of Aggregation After A Merge In Power BI And Excel Power Query/Get&Transform (@cwebb_bi) Power BI Report Server Update – March 2018 Coming soon to Power BI: Common Data Service for Analytics BONUS ITEMS: Power BI Roadmap […]

Microsoft's 'Spring '18' refresh of its Dynamics 365 services includes some major new development and analytics tech under the covers: The Common Data Service for Apps and for Analytics.

A while ago I wrote a blog post explaining how to Export Power BI Data to SQL Server with R. In that post I explained how to get the job done in Power BI Desktop using R scripts. In this post I explain how to export Power BI Service data to SQL server. YES! … Continue reading Export Power BI Service Data to SQL Server →

Power BI: Change parameters & data sources directly in Power BI service with the new online feature

As I am sure a lot of people noticed if you now go into the settings of your dataset there is an additional option which says Parameters. What I wanted to test out was to see if I could change the …

My 2010 Wake Up Call Eight years ago, I lucked into an epiphany: IT-driven BI was going to give way to biz-driven BI (aka “self-service” or “Agile” BI). The new wave of BI tools – led by Power Pivot at the time, which ultimately grew into Power BI – gave business subject matter experts something they’d previously

A blog from the SQL Server Reporting Services product team at Microsoft.

In the business application virtual launch there have been presented so many things that look (almost) too good to be true. Also check out the in-depth-demo of Power BI and you might understand why my absolute favourite is the common data model and the new common data service for analytics. They a...

One of the new features of the Common Data Service is to use Power Query to create custom entities that are linked back to external data. This data could reside in a number of different places, inc…

March turned out to be another exciting and busy month for Power BI. We rolled out some highly anticipated features in the service and continued to make progress with many more that are set to…

Useful Data Sources for Demos, Learning and Examples (@jenstirrup) Why is Vertipaq so fast? Part 3: Segment Elimination (@CurbalEN) Power BI GDPR Whitepaper Editing Q&A linguistic schemas Power BI Service and Mobile March Feature Summary Power BI Desktop April Feature Summary BONUS ITEMS: Power BI Feature Spotlight: Using Bookmark Buttons to Create Pop-Up Windows (@PowerPivotPro) […]

A workaround to deploy Power Query solutions from Excel or Power BI to a local Analysis Server via Azure Analysis Services.