If you work with Power BI on a regular basis and you don’t yet know about Tabular Editor, you are doing yourself a huge disservice. It can make life so much easier, massively speed up the development process and save you the heartache of silly errors and these reasons are only the tip of the […]
Power BI
Power BI, how to see new columns in a CSV fileWhen working with Power BI, what happens when you have a new column added to you CSV file? When you refresh your data there is a very strong chance you won’t see the new column in you dataset. So how do you get Power Query to see the new column? Read on for the answer. […]
Power BI
Simple way to get Power Query Intellisense to work (NO DOTS!)Power query intellisense can be really frustrating to use, but there is a simple solution… No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need & when you tab to accept, it […]
KISS
Power BI
How to get the duration between two datetime or date fields in Power BII had to do this recently and struggled a bit to begin with. Thankfully once I figured it out it was quite easy to accomplish, like most things, it’s always easy when you know how. Below is a view of the fields in question in Power Query: What I wanted to get is the duration […]
KISS
Power BI
Can I use Power BI for free?100% yes! In fact I would encourage you to start this way as there is much to learn before you need to use the parts that cost money. Power BI desktop is the place where you will do all the primary work. This part is totally free and Microsoft have guaranteed that this will never […]
0