Power BI

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.

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 connection strings using the Parameters in the Power BI Service. The advantages of this working in m...

In this video, Adam looks at how you can update Power BI parameters within the service or by using APIs. You can create Power BI Parameters within Power BI Desktop using Power Query. Then you can update those Power BI parameters once the report is published to the Power BI service. PowerShell Samples

These are GREAT news! Finally we have a way to refresh data from custom connectors on the Power BI service. Surprise! You can now refresh custom connectors through the Power BI personal gateway (requires April 2018 version) https://t.co/SUF4CEuQBA#pqsdk — Matt Masson (@mattmasson) April 22, 2018 Step 1: Get a Power BI Custom Connector The first …

Just wanted to share a hack of the problem that you can’t determine the sort order of your reports in the service so they will also be sorted alphabetically. But by using little trick you can…

We are excited to announce that we have just released the April update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release:…

This blog post covers the latest updates for Power BI Developers community- Power BI Embedded and Custom Visuals.

April turned out to be exciting month for the Power BI team. Mostly because we got to meet many of you, our awesome community members, at the Data & BI Summit in Dublin. Huge thank you for those…

Today, as part of Build, we announced that Power BI Custom Visuals will be rolling out in Preview to Office 365 subscribers enrolled in the Office Insiders program soon, extending Excel charting capab…

Fun with Graphing in Power BI – Part 5-by-5 (@GregDeckler) Power BI Architecture Guidelines (@Rad_Reza) Build a Collapsible Slicer Pane for Power BI (@dataveld) On-premises data gateway April update i…

As a quick follow-on from last week’s post on how to detect whether query folding is taking place when importing from OData data sources, if you’re importing data from Analysis Services you have a …

A lot of people have problems with the performance of OData data sources when loading data into Power BI and Excel. One possible cause of these problems is query folding not taking place – if this …

How to Create A Real-Time Dataset on Power BI.com Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots. So this post will be in moving picture form! We’ve