service

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 …

This weeks webinar will highlight a community tool called Power BI Helper that helps you explore, tune and document your Power BI reports by Reza Rad.

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…

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…

Fun with DAX – A-Maze-ing DAX (@PhilSeamark) 24 Days of PowerPlatform – Day 1 – Let’s kick it off.. (@wstrasser) Power BI Fast and Furious with Aggregations (@Rad_Reza) Power BI Dataflows and Slow Dat…

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…

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…

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 …

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…

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…

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 …

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…

What happens if you ignore this metadata? Are all metadata attributes equally important? Are all metadata attributes equally applicable to a given usage scenario? What are the risks of using the da…

Using Presentation mode in the Power BI app running on Surface Hub in your conference room and collaboration areas, better allows you to have meetings which focus on your data. Presenting, collaborati…