When working with long measures in #PowerBI, it is easier to create them in the Data View
I have been working with a lot of DAX at the moment and the new DAX area is awesome. What I have found at times when working in the Report View, is that when I edit the DAX measures, I sometimes have to click on the arrow multiple times in order to get it to back up. This can be…
Power BI RoundUp – Dataflows Data Lineage | MBAS 2019 | On-Premise Data Gateway Update | Colour Theme Survey
Hi there, another week, another Power BI RoundUp with more awesome features from the Power BI Team Power BI – Dataflows data lineage When you are using dataflows there now is an option to view the data lineage. What this means to me is a visual representation of where and how your data is flowing within your dataflows. This is…
How did I use the new Rounded Borders feature in #PowerBI Desktop to make shaded charts
In this blog post below, I am going to show you how I used the new Rounded Borders feature to create shaded charts with rounded borders as shown below. I used the new Rounded Borders feature that was released Power BI Desktop – Feb 2019 Rounded Borders This is what it looked like once I had completed the following steps…
How to get one table to refresh in a Power BI Data Model
I was recently working on a large Power BI Data Model and I did not want to refresh the entire data model for my updated dataset to come through. This would mean refreshing the large Fact table with a few million rows and a complex underlying TSQL query. All that I required was to get a new value in my…
Power BI RoundUp – End user filter export capabilities | Template Apps | Developer Community Update
Welcome to another Power BI RoundUp, and fortunately this week has been a quieter week, which has worked out well because I have been attending the Difinity Conference in New Zealand where I have both presented on Dataflows. I also attended a lot of great sessions and met new and existing people. Here are the updates End user filter export…
Do you know how to use Multiple Disconnected Slicers in Power BI?
I had previously blogged Power BI – Using a Slicer to show different measures where I showed the steps on to have a different measure based on a slicer selection. I got a few comments from that blog post, where people were asking if it was possible to have multiple Slicers which could be used. If you are reading this…
#PowerBI RoundUp – Power BI Desktop release for Feb | Gartner Magic Quadrant | Service & Mobile Update for Jan | Petabyte-scale Analytics with Power BI & Azure | Incremental refresh & query folding | Premium Capacity Metrics Webinar
Well a lot has happened in the last week, with the desktop release (YAY!), and a whole host of other details. Read below for more details on what has been updated and from my perspective. Power BI Desktop Release for Feb Every month the awesome people on the Power BI Team release new features and this month is no different!…
Why is my #PowerBI dataflow refresh failing
I was recently testing out the new awesome dataflows in Power BI, and no matter what I did my dataflow refresh would fail. I was getting the same error no matter what I did. In order to find the error details for my dataflow I did the following: I went into my App Workspace and then clicked on the settings…
Power BI RoundUp – Export to PDF & On Demand Email Subscriptions | Premium Capacity Metrics App Update | Difinity Conference | Power BI APIs with Service Principal | Bulk Operations in the Admin Portal | Webinar on Personal Bookmarks in the Power BI Service
Hi there, I cannot believe it is already February. This year is already starting to fly by. Please find below my weekly Power BI Round Up. Export to PDF & On Demand Email Subscriptions As you can see above you can now schedule your email subscriptions. Not only that but coming to the Power BI Service is the ability to…
Where can I find all the data sources for my #PowerBI report?
I have found that at times people get other Power BI reports and are not sure what data sources there are in the file. As well as which data sources are connecting to what? In this blog post below, I will show you where you can find all the data source details. In my sample PBIX I have connected to…