How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV
I was helping and answering some questions on the Power BI community forums and I came across a question where someone was looking to query data from Power BI Premium using SSIS (SQL Server Integration Services). This is definitely possible and I will show you below how I can use SSIS, to query data from Power BI Premium and store…
Intro into Power BI Premium
I was chatting to my good friend Treb Gatte and one of the things we both discovered is that there was not a good blog post with regards to an introduction into Power BI Premium. I thought this was a great idea and have turned it into this blog post below. I am going to cover the following sections below…
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…
Why do I have to pay for Power BI Premium features?
I generally see quite a lot of questions as to why certain features are only available in Power BI premium. In this blog post below, I am hoping that I can explain as to why there is a cost associated to them. Power BI Pro Let me start by saying when I log in with Power BI Pro, I am…
Power BI RoundUp with SQL Pass updates – Dataflows – Paginated Reports (SSRS) – Premium Metrics App with Data Flows & Paginated Metrics – Paginated Reports in Mobile App – Mobile & Service Update for Oct – Bonus features coming to Power BI Desktop
As expected this week with SQL Pass, there has been a whole host of new capabilities and features in Power BI, so please see my roundup below with the relevant links below. And even though there is a lot of announcements here, we are still waiting for the update to Power BI Desktop!! Power BI Dataflows One of the biggest…
Review of new Features coming to Power BI by Oct 2018 – From Business Applications Summit
I was fortunate to attend my first ever Business Applications Summit in Seattle. I had the pleasure of sharing an Airbnb with Matt Allington, Phil Seamark and Miguel Escobar, it was great to spend time with these Power BI Legends. I also did meet a lot of people and got to chat with people in the Microsoft Power BI team,…
BI-RoundUp – Power BI (Power BI Desktop June update – Subscribe others to Email Subscriptions – Developer Community for May, Service & Mobile Update)
Here is my weekly BI-RoundUp, and once again the awesome people from the Microsoft Power BI Team have released some additional gifts. Power BI Desktop June Update Here is another month of big updates to the Power BI Desktop. Reporting The first item is now based on your contrast settings, this will be applied to the Power BI Desktop file…
BI-RoundUp – Power BI (Power BI Update May 2018 – Custom Visuals in Excel – Service & Mobile Update – ArcGIS Online & Plus Subscriptions )
Here is my weekly BI-RoundUp and it is great to see that the monthly update for Power BI is here, as well as some other details of the new items. Power BI – Update for May 2018 As always here are the updates for Power BI Reporting As shown above the first item is that you now can have conditional…
Power BI Premium/Premium Per User – Automating Processing of historical partitions
I recently had a big challenge with one of my customers where due to the sheer volume of data and network connectivity speed I was hitting the 5-hour limit for processing of data into my premium per user dataset. My solution was to change the partitions from monthly to daily. And then once I have all the daily partitions merge…
How to enable dataset sizes larger than 10GB for Power BI Premium or Power BI Premium Per User
By default, when using Power BI Premium or Power BI Premium per user the dataset size is set to 10GB. I have had the wonderful experience of refreshing my dataset and getting the following error: In the steps below I will show you how to change this setting to allow for larger dataset sizes. Finding the dataset GUID The first…