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…
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…
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,…
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…
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…
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…
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…
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…
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…
BI-NSIGHT – Power BI (Featured Data Stories, Dashboard Makeover, Office 365 Adoption Content Pack, JIRA Content Pack) – Excel (Get & Transform Update)
Here are this week’s BI-NIGHTS updates. Power BI – Featured Data Stories There are some great data stories featured in the Power BI Data Stories showcase. I have to have a special mention to myself that I managed to get my Create Dynamic Periods for…