Announcing General Availability of Custom and Certified Connectors for Power BI
I am happy to announce that Custom and Certified Connectors in Power BI are now generally available!OverviewAfter delivering the Power BI extensibility framework, our incredible community has…
Power BI RoundUp – Webinar on Advanced Data Prep – Data Flows in Power BI – On-Premise Data Gateway Update – New Power BI Regions in Azure – General Availability of Custom & Certified Data Connectors
Here is my weekly Power BI related round up, I hope that you find this information relevant and keeps you up to date with everything that is happening with regards to Power BI. Power BI – Webinar o…
Running Power BI Reports or Dashboards in Fullscreen without the Buttons
I had seen some questions in the Power BI Community when asking how to run reports or dashboards in a browser screen so that they cannot see they buttons on the bottom left hand side. In my example…
Announcing new AI Capabilities for Power BI to make AI Accessible for Everyone
At Microsoft, our mission is to empower every person and every organization on the planet to achieve more. Power BI makes it possible for every employee in an organization to make better decisions bas…
Important Considerations for Setting up Incremental Refresh on Power BI Desktop
This simple and brief article is about Incremental Refresh setup in Power BI. By the end of this article, you will know more about incremental refresh, its advantages and setup process. What is incremental refresh? Incremental refresh is a feature in Power BI premium which enables more reliable,...
Today marks the 20th birthday of Analysis Services: it was released (as OLAP Services) on November 16th 1998. There’s a celebratory blog post and video over on the Power BI blog here: I’m one of th…
Use Power BI dataflows to warehouse SharePoint list data -
Warehousing SharePoint data has been a need that has been with us for a long time. Power BI dataflows finally provide a reliable way to solve this need.
How to use A SKU’s to try out Paginated Reports in Power BI without upfront cost or long term commitment
Since the Eagles game doesn’t start until later, thought I’d put this together for folks. As many of you know, earlier this month we announced a preview of Paginated Reports in Power BI. While fol…
DBAs can use PowerShell cmdlets to manage Power BI workloads. Learn how the Power BI-PowerShell combination provides an efficient way to manage data sets, workspaces and Power BI reports.
How to Programmatically Pass Credentials in Embedded Power BI Report
Currently it is not possible to implement user impersonation in an embedded Power BI Report Server. However, like in most scenarios, there are workarounds..
A few weeks ago I wrote an article introducing dataflows in Power BI and discussed why you should care about them. There are a few questions that have been spinning around in my head since then, s…
How to automate collection of Power BI activity data
In this blog I would like to cover how you can automatically load all Power BI activity data into a database for detailed analysis across different workspaces. We are realizing this using and Azure fu…
Azure BI Resource Management via SSIS and PowerShell
In this week’s episode of Insight Quest, Brett, a BI consultant from Frontline Analytics, has been assigned tasks related to the programmatic management of Azure Analysis Services and Power B…
Power BI RoundUp – Help Shape the Future of Power BI – On-Premise Update for Nov 2018 – Modeling Vie…
Here is my weekly roundup, and whilst it has not been as busy as the past few weeks, there are still some awesome updates. Power BI – Help Shape the Future of Power BI I always think it is really i…
Are Power BI Dataflows a Master Data Management Tool?
Are Power BI dataflows a master data management tool? This guy really wants to know. Spoiler alert: No. They are not. When Microsoft first announced dataflows[1] were coming to Power BI earlier thi…
In case you don’t agree with this guy from that meme, you should go to ideas.powerbi.com to let the dataflows team know what you think, and why. The “ideas” site is a feature voti…
There are two common misconceptions that I see related to Power BI dataflows and Power BI Premium. This goal of this post is to dispel both of them. Misconception #1: Power BI dataflows are a Premi…
It’s been two weeks since Power BI dataflows became publicly available in preview, and there’s been a flood of interest and excitement as people have started exploring and using this ne…
Filter Excel Function CUBEVALUE Connected to Power BI
You might know that we can connect Excel to Power BI using “Analyze in Excel” feature. If this is something new for you – check out following video (3 min) By default, after click…
This is a question that comes up all the time. Power BI licensing is not complicated but a common challenge is that the person who sets up a new Power BI subscription and tenant within an organiza…