BI-RoundUp – Power BI (June Desktop Update – Data Insights Summit Details – Power BI Embedded Pricing & Details – Power BI Premium Generally Available – Power BI Report Server Generally Available)
I was fairly certain that there were going to be a whole host of updates and additions to Power BI, and I can say that I am not disappointed. There is a whole host of information below, where I will endeavour to try and get it all to you, so this might be a bit long to read, but it…
BI-RoundUp – Power BI (Service Update April & May – Personal Gateway Update – How to Purchase Power BI Premium – Managing Power BI Premium – Memory Consumption in Power BI File – Power BI – Exposing M Code)
It has been a busy week with the start of another month leading into June, so here are the updates. I am pretty confident that with the Microsoft Data Insights Summit happening Monday & Tuesday of next week that the new version of Power BI Desktop, as well as some new features will be revealed then. And I cannot wait,…
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…
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…
Power BI Query Editor – Getting IP Address Details from IP Address
I recently had a question from a user in the Power BI Community page who wanted to know where the people were coming from based on their IP Address. The IP addresses were stored as part of the dataset, but to try and go and do this with the IP Address database meant that you would then need to go and…
Power BI – Power Query/Query Editor Automated Source Control
I saw a blog post recently where Jay Killeen was talking about how he handles his Source Control for the Query Editor or Power Query. And this got me thinking of how I could automate this in a quick and easy manner. So below is how I achieved this. My solution below, uses a BAT file and 7zip, which means…
Power BI – Getting your report to always filter this month’s data dynamically
I had a requirement where I needed to have the capability to set the filter once on a report for the current month and then it dynamically move as each month progresses. I will show how I completed this in the steps below. NOTE: As with almost all Power BI Models, this is going to be leveraging off my Date table…
Power BI – Quick Tips working with multiple large CSV Files
I have recently been working a lot with multiple larger type CSV files, and thought it would be good to share what I have found that makes the process run faster. I am always looking at ways to make sure that not only is the model efficient, but also the development experience. Name your query first before applying steps in…
Power BI – How to Easily Create Dynamic Date Table/Dimension with Fiscal Attributes using Power Query
I have been working on some new projects and one of the things that I found that was whilst you can find examples of creating Date tables, I could not find any examples of where the Date table included Fiscal Attributes such as Fiscal Month, Fiscal Quarter and Fiscal Year. So in this blog post I am going to show…
BI-NSIGHT – Power BI (Secure and Audit Power BI, Data Driven Parameters, Snowflake Data Connector) – Excel (Get & Transform Updates / Power Query Updates)
Here are the BI updates for this week. Power BI – Secure and Audit Power BI One of the questions that is regularly asked with regards to Power BI is around how secure the data is. And along with that is how do people gain access. This new update goes a long way not only to make Power BI more…