Enabling External Power BI Users to easily view App Workspaces or Apps shared with them
Having the capability to connect external people (B2B) into your data within Power BI is a great feature and a huge advantage when comparing to other customers in my opinion. In this blog post I want to demonstrate how to easily allow external users to always find the data that they have access to in other organizations. I have been…
DAX – How to get a line break in a DAX measure for Labels or Titles in a Power BI report?
Once again, I really enjoy working with Power BI and in the data and analytics space. I was at a customer and they were drilling through between pages, and I wanted to put in what the filter selections were when they drilled through to the new page. This would allow them to easily see what had been on the previous…
How to connect to your Power BI Premium Datasets using Excel (with the XMLA End Points)
I have had seen a few questions in the Power BI Community, as well as from other people asking if it is possible to connect directly from Excel to a Power BI Premium dataset from Excel. Without having to log into the Power BI Service or download any .ODC files. I am going to show you how to do this…
How to setup and get a Certified Dataset in #PowerBI
There is the new functionality in the Power BI Service where you can now get your data certified. In this blog post I am going to explain all the steps involved to getting a dataset certified. Some of the steps below will require a Power BI Admin to complete certain steps. As described in the documentation not all datasets will…
Embedding Word Documents into new App Experience within #PowerBI
I was recently fortunate enough to go to the Microsoft Business Applications Summit where I had a great experience. One of the things that they did talk to, was creating links within the New App Experience which could link to other web pages or documents. This is really an awesome feature, and it enables users to stay within the App…
Review of new features & Announcements for #PowerBI – From the Microsoft Business Applications Summit
I was once again very fortunate to make it across to the Microsoft Business Applications Summit in Atlanta. I had 3 sessions which I presented at, and they went well. It was great to meet new people (some of whom I had only read their blog posts or viewed their videos) and reconnected with existing people. As I did last…
Power BI Premium Performance – Part 5 | How much memory will the PBIX consume?
This was something that I thought I had covered off already and was one of the key messages that I wanted to get across when looking to move to Power BI Premium. It can be quite confusing when always thinking about the size of a PBIX file being smaller than 1 GB and then moving to Power BI Premium where…
Power BI RoundUp – Enhanced attachment support for Paginated Reports
It appears that this week the good people on the Power BI team are busy working away to release some awesome new features next month. Below are the latest updates, I hope you enjoy the read! Enhanced attachment support for Paginated Reports As you can see from above there is now enhanced support for attachements that are sent as part…
Power Query – How to get the output from a table as a value or an item
I was working on a customer’s data where I wanted to get the output from a table, but have it stored as a value or item. I am sure that in the comments there might be a possible way to do this more efficiently, but below is how I solved this challenge. As always it is best to work through…
Power BI RoundUp – Power BI Desktop May 2019 | Custom Navigation for Power BI Apps | Power BI Report Server May 2019 | Meet the community stars at MBAS | SQL Server 2019 SSAS CTP 3.0 | Trusted 3rd Party Connectors
Welcome back to another Power BI RoundUp! It has been a fair while and to be honest I have been extremely busy with a client planning for and looking on how to best leverage Power BI for their reporting requirements. Let’s get started with the latest updates. Power BI Desktop May 2019 Another month has come and gone and there…