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…
Power Query – Adding Parameters within a piece of text
Below is where I had a situation where I wanted to put in a parameter within a piece of text. This was so that I could then dynamically change the Month Version for my budget and when I refreshed my data it would then use my specific Month Version. This was due to the requirement being that they wanted the ability to…
Power BI – Create Last Dataset Refresh Date
Whilst I have read and found other ways to get the Last Dataset Refresh Date, I find that my method is a lot easier and cleaner to complete. Creating the Last Dataset Refresh Data Open Power BI Desktop and go into the Query Editor. Then click on New Source and select Blank Query Next I renamed my Blank Query from…
BI-NSIGHT – Power BI (Design your own Swag, Custom Refresh Schedules for Live/DirectQuery, Report Theme Gallery, Custom Visuals Community Site, Filter a report with a URL query string, Summit EMEA, Custom Visuals in Office Store, Data Insights Summit Session Details
Once again the world of BI is very busy with great new features and other details which I have put into this blog post below. Power BI – Design your own Swag There is a competition to design your own Swag Shirt for Power BI. As you can see above is my entry, so if you like it, please go…
BI-NSIGHT – Power BI (Custom Refresh Schedules for Live/DirectQuery, Report Theme Gallery, Custom Visuals Community Site, Filter a report with a URL query string, Summit EMEA)
Once again the world of BI is very busy with great new features and other details which I have put into this blog post below. Power BI – Custom Refresh Schedules for Live/DirectQuery I have to say I have noticed that the Power BI team are currently releasing a lot of features which give a lot more granular control to…