Refreshing data in Power BI from SQL Server Read-only or Secondary Replica’s (@GilbertQue) Quick Measures in Power BI: You don’t have to write DAX!? (@Rad_Reza) How to use A SKU’s to try out Paginated…

Power BI Visual Usability Checklist (@mmarie) Get the most out of Power Query in Power BI Dataflows (@diverdown1964) Analysis Services is 20 years old! Announcing new AI Capabilities for Power BI to make AI Accessible for Everyone Power BI Desktop November 2018 Feature Summary BONUS ITEMS: Tableau to Power BI: Highlighting with Set Actions (@dataveld) […]

With data lakes becoming very popular, a common question I have been hearing often from customers is, “Should I load structured/relational data into my data lake?”. I talked about this…

Hi, I use a Personal Gateway to auto-update my Datasets. One data source - Sharepoint, is now throwing an error. I can log into Sharepoint fine normally, and it refreshes in my local Power BI file, but the online credentials suddenly don't work. Oddly, when I check t...

Hi I have installed an on-premisis gateway- It is online and all connections are online too: I am using this gateway to refresh, and everything seems fine: But when I try to refresh, I get an error, saying that my PERSONAL gateway is offline: Everything worked until November 8th. I ha...

Our data gateway has been occasionally failing scheduled refreshes with 'gateway unreachable' errors which I'm fairly confident are because the machine was taxed by other data processing tasks, so to remedy I've added a second data gateway to the same cluster and set the cluster to distribute querie...

If you’ve been reading this blog, you already know a few things: Power BI includes a capability for self-service data preparation called “dataflows” Dataflows include computed ent…

Q: What are Power BI dataflows? A: Dataflows are a capability in Power BI for self-service ETL and data preparation that enable analysts and business users to define and share reusable data entitie…

Hi everyone, it’s guest blogger Paginated Report Bear! Well, actually, Mr. Chris agreed to type for me since I don’t have fingers. Anyways, if you watched my intro video, I promised you all I’d ma…

In this week’s webinar the Report Server team will answer your questions about paginated reports for Power BI Report Server AND show you the answers live. Don't have any questions? Not to worry we will have the team pull out their favorite demo and show why you should start using paginated reports now.

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

Currently it is not possible to implement user impersonation in an embedded Power BI Report Server. However, like in most scenarios, there are workarounds..

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.

CDS for Apps VS Power Query – is there a difference? If so, what is that difference? Are they mutually exclusive or complement each other?

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…

We are happy to announce that we have just released the November update for the On-premises data gateway (version 3000.0.155.1) &…

Unlock all of the power of Power Query in Power BI dataflows