Category: Technical
I’m so excited to see Optical Character Recognition (OCR) working natively now in Office 365! I got my start in government where we scanned a lot of documents. There was a lot of data locked away in those images but no easy way to mine it. OCR was explored as a possible solution, but it […]
This post shows you how to use the date hierarchy and the grouping function to easily group your data by year, month, week in Power BI. This can be very handy when reporting against data that is timephased, such as sales transactions or Project Online schedule and capacity data. If you need to start your […]
In this installment, the user facing aspects of your Power BI report models will be discussed. Much of this is considered fit and finish work. It is important that you take the time to address these issues as PowerBI.com enables users to build their own reports and dashboards from your data sets. This finish work […]
Professional chefs use a French kitchen organization approach called “Mise En Place”, which means literally, “putting in place.” It ensures that the placement of ingredients and utensils are optimally placed for efficient cooking. Power BI report models can require the same type of approach to ensure that your report models are maintainable over time. This applies […]
Are you having tired of waiting for long refresh times with Power BI? Perhaps, you are getting timeouts because you are retrieving too much data. There’s three easy ways to avoid these issues. WHY IS MY POWER BI DATA REFRESH SO SLOW? Many Power BI models refresh slowly as the models are not structured to […]
Don’t you hate it when you can’t read the field descriptions on your SharePoint list columns? It’s helpful to explain the values to your users but it’s usually hard to read. Try this Thursday’s Tech Tip to make your descriptions more readable. Video Notes This technique does not work with Project Server Project Detail […]