Power BI – Configuring SharePoint/Folder refreshing using On-Premise Gateway
I had a requirement to connect and refresh their files stored in SharePoint On-Premise using the On-Premise Gateway. And are the steps that you can follow in order to connect to files stored within SharePoint On-Premise or files stored in Folders. In my working example below I am going to connect to a SharePoint Folder. You can apply the same steps for a…
BI-NSIGHT – Power BI (Premium, May Desktop Update, New Pricing 01 Jun 2017, Pride 2017, Azure Consumption Insights Content Pack)
I always anticipate that the start of each month will be busy with the updates to Power BI, but this month is an exception with not only the release of the May Power BI Desktop Update, but also a new pricing and capacity model with regards to Power BI Premium. So let’s get into it shall we. Power BI –…
What makes up a Power BI Desktop PBIX File
I know that I personally have been interested in what makes up a PBIX file and in this blog post below I will explain from my understanding what are the different parts that make up the PBIX file. It is rather interesting in that it is actually made up of a few different aspects.
BI-NSIGHT – Power BI (Meet 1:1 with Microsoft Expert – May & June Webinars, Sample files as PBIX, Quick Measures Gallery, Mobile App Update – April)
Here are this week’s updates, with May starting next week I am looking forward to some interesting updates with regards to Power BI. Power BI – Meet 1:1 with Microsoft Expert If you are attending the Microsoft Data Insights Summit you now have the opportunity to have a 1:1 session with a Microsoft Engineer for 15 minutes. If I was…
Power BI – On-Premise Gateway Configuration steps to an Oracle Database
I was recently working in an environment where the requirement was to connect to an Oracle database using the On-Premise Gateway, so that we could either DirectQuery or import the data and then refresh it using the On-Premise Gateway. So the steps below detail how to complete this successfully. The example below was connecting to an Oracle databased called TRID
BI-NSIGHT – Power BI (Community Blog Highlights – Power BI Germany – Latest Updates for Power BI Desktop – How Microsoft uses Power BI to run its Cloud Business – Connecting Datasets to Power BI Service) – SQL Saturday Brisbane (I’m presenting) – SQL Server (SQL Server 2017 – DAX Editor for SSDT – New Get Data Experience for SSDT)
I thought that this might be a quieter week, but once again there are a whole host of updates from Power BI updates, to SQL Server 2017 announcements. Quite a bit to read through so I hope you enjoy it. Power BI – Community Blog Highlights I actively participate in the Power BI Community, as well as when I feel…
Power BI Dataset tips and potential pitfalls
There has been a lot of hype around the new feature in the Power BI Service where you can connect directly to the Dataset in the Power BI Service There have also been quite a few blog posts on how to connect and leverage the datasets in the Power BI Service, what I am going to focus on is around…
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…
Power BI – Free vs Pro Infographic
I have been active on the Power BI Community Page for quite some time, and what I have often seen is people not quite sure what options are free and what options require a Pro license. So here is my infographic in which I have put down which options are free and which options will require a Pro license. I…
BI-NSIGHT – Power BI (Desktop Update April – Quick Measures Preview – Mobile Apps Summary – Video Gallery & Ask a Partner Anything – View Related Content Pane – Sneak Peak add new Columns from Example – Tracking Adoption via Power BI Audit Logs)
There has been a whole host of updates and interesting things in Business Intelligence in the past weeks, so please find below the updates. Power BI – Desktop Update April This month’s Power BI Desktop update for April has a whole host of great updates and new features this month, which I will highlight what I think is most relevant…