Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services
Recently I have been working where I have multiple accounts, and I wanted to test the different access to the accounts when connecting via Excel. I could not find any blog posts or videos on how to do this. In my blog post I detail how to achieve this. Connecting to the dataset using Excel The method below will work…
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 enable Excel Pro’s to use Power BI Datasets
In the steps below, I am going to demonstrate how to access your Power BI Dataset through Excel. This is a great example for people who love Excel and use it as their tool of choice, but the company or organization still wants to have a single version of the data. By leveraging the steps below the data is available…
Power BI – DAX Measures for Excel based “ % of Column Total “ or “ % of Row Total ”
Where I am currently consulting there was a requirement to create a measure like you can in the Excel pivot tables for the % of Column Total or the % of Row Total. One of the things that you can currently do in Power BI, which I only learnt as part of this requirement is that you can use %…
BI-RoundUp – Power BI (Office 365 Adoption Content Pack – Embedded Accelerator) – Excel (Get & Transform Updates May 2017)
This will no doubt be a quieter week, leading up towards the end of May and into June when there will be the next wave of updates from the Microsoft Power BI Team You might also notice that I have changed the name from BI-NSIGHT to BI-Roundup, as there was another blogger who has his blog URL as BiInsights, so…
BI-NSIGHT – Power BI (Service March Update – New Navigation Experience, Desktop Terms & Definitions – Whitepapers) – BI Survey (BARC BI Survey 2017) – Excel – (Get & Transform Updates for April 2017)
There has been a variety of updates and blog posts in the past week, so here are my BI updates. Power BI – Service March Update There were quite a few service updates for March within the Power BI Service. The first was the granular controls which was a very welcome feature. And I know that something that a lot…
BI-NSIGHT – Power BI (Granular Tenant settings, Amazon Redshift connectivity in Power BI Service, Featured Data Stories, Availability Monitoring Publish to Web) – Excel (Get & Transform updates) – SQL Server (DAX support in Report Builder and SSMS)
Here are the weekly updates. Power BI – Granular Tenant Settings I can personally say that I know a few of my clients who are very happy that the Power BI team has already implemented the Granular Tenant settings for Power BI. I have to say that I am once again impressed by the Power BI Team really a great…
BI-NSIGHT – Power BI (February Desktop Update, iOS Mobile App with Q&A, Dual KPI Custom Visual, PowerApps Common Data Service) – Excel (Get & Transform Updates for January)
I had to re-write this, as I had a suspicion that the Power BI Desktop would be released soon and here it is, along with other updates. Power BI – February Desktop Update This Power BI Desktop update is here, and I have to say that there are some awesome additions and new improvements. So I will highlight below what…
BI-NSIGHT – Power BI (Mobile App Update – Android Tablets, Navigation Preview, AMA, Driving Power BI Adoption in your Organisation) – Excel (Get & Transform Update)
It does appear that as we approach the festive season, the Microsoft team are still full steam ahead, which is great for myself and the Data Analytics community. Power BI – Mobile App update for Android Tablets As per their blog post, it is great to see that there now is an App for the Android tablets, whilst this has…
BI-NSIGHT – Power BI (Desktop Update Oct 2016, Features Coming Soon, R Visuals without understanding R, Community Blog Highlights, Custom Visual Stocked Bar, InsightCentr Content Pack, Webinar Nov 1 Big Data with HDInsight & Datameer, Advanced Analytics with Power BI Embedded and R) – Excel (Get & Transform Updates Oct 2016)
Well there sure is a lot of information with regards to BI in the past week, now that PASS has finished, as well as the end of the month, so there are some great Power BI updates as well. Power BI – Desktop Update Oct 2016 Another month has come to an end, and with that we get a whole…