Power BI

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

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.

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…

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…

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…

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? 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…

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…

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.

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…

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…

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…

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...

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...

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...

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…

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) […]

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 Service and Mobile September & October Feature Summary Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop Public Preview of Paginated Reports in Power BI…

One advantage of data warehouses is the ability to have data from multiple data sources available for analysis without being constrained by the availability and performance characteristics of those da…

A Power BI administrator is a role for managing various aspects of the Power BI Service. This role can be assigned in Office 365. Anyone with Office 365 global admin privileges is also a Power BI administrator by default. Based on the tests I've been doing, I've observed that users with membership

I didn’t plan on writing a sequel to my Positioning Power BI Dataflows post, but a few comments I’ve seen recently have made me think that one might be useful. I also didn’t plan …