How do Power BI datasets and dataflows relate to each other? Do you need one if you have the other? I received this question as a comment on another post, and I think it warrants a full post as a r…
Choosing Between Power BI Premium and Azure Analysis Services
Yesterday I posted an article comparing Power BI dataflows, Power BI datasets, and Azure Analysis Services. Although I’d like to believe that the article was useful, I used the disclaimer …
Azure Data Lake Storage Gen2 preview – More features, more performance, better availability
Since we announced the limited public preview of Azure Data Lake Storage (ADLS) Gen2 in June, the response has been resounding. Customers participating in the ADLS Gen2 preview have directly benefi&he…
That title got your attention, didn't it? Before we move on, no, you cannot create and publish dataflow entities from Power BI Desktop today. Creating dataflows is a task you need to perform in the br…
Power BI RoundUp – Ask a follow up question, Help Improve Power BI
As I am typing this I am wondering if tomorrow I will have to update it with the new Power BI Desktop features, or if this will be coming out next week! Here is my weekly Power BI RoundUp Power BI …
Lego Bricks and the Spectrum of Data Enrichment and Reuse
I love Lego bricks. I love them because they were a favorite toy from my childhood. I love them because my children love them. I love them because they foster and encourage creativity. I love them bec…
Power BI – How to Configure “Send Refresh Failure Notification email to Distribution List (Multiple Users)” for Dataset refreshes
As it currently stands when I setup a dataset refresh it only emails me when it fails. I was recently at a customer where there is a team of Power BI Developers, and I wanted to find a way that all…
Ask a question using natural language December 2018 update
You did know that Power BI supports natural language queries, right? All you need to do is to add the Q&A button to your report and your customers will be able to navigate their data just by asking qu…
Ask Me Anything Unanswered Chat Questions Answered
Last week, I participated in an “Ask Me Anything” session where I answered questions around both Paginated Reports in Power BI, as well as questions around SQL Server Reporting Services and Power B…
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 …
How Permissions Work for a Power BI Service Administrator
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
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…
Power BI Updates - Dataflows, Paginated reports, Metrics app and more... (November 12, 2018) | Guy i…
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…
Power BI Dataflows, Quick Measures, Paginated reports and more... (November 26, 2018) | Guy in a Cub…
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 visuals, Dataflows, AS Birthday and more... (November 19, 2018)
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…
Data Source Credentials failing for Sharepoint suddenly (using a Personal Gateway for refreshes).
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...
Power BI Dataflows – Data Profiling Without Premium
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…
Download Paginated Report Bear’s sample paginated report for Power BI
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…
Webinar 11/27: Paginated reports for Power BI Report Server -Meet the team and ask them anything | Microsoft Power BI Blog | Microsoft Power BI
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…
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…
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…