There are sseveral things that will come into play after you have created a dashboard in Power BI. One of them is making it leaner by removing all unused items (measures and columns) in the imported tables. This is not so easy to do - but here is a solution - kind of ...
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the article to include excel. The result is below and is
I attended Microsoft's EduCon 365 conference in Washington D.C. from June 12 to June 16 of 2023. Through Experts Exchange's ReConnect program I received a partial "scholarship" to subsidize my registration. So what was this conference about and what did I get from it - read on!
Power Business Intelligence (PBI) from Microsoft is fairly robust and easy to use. Still, there are several items in the PowerBI editor that will help you save time - especially in the long run.
Over the past couple of years I have tried over and over to make certain PowerBi elements display the way I want them to, without much positive results. Here is how I solved the problem.
Learn about Power Excel add-ons and how to use them.
Power Pivot. Get and transform (Power Query).Power View.3D Map (Power Map).Extra Power BI.Power summary video (Spanish)
With Windows 10, Microsoft has come up with built-in support for Intune data protection policies. This is a two-part series. In this 1st part, we look at how and to what extent we can safeguard corporate data on Windows 10 workgroup machines (BYOD) with Windows Information Protection and Applocker
How to build an Excel spreadsheet that allows users to enter select values via populated combo boxes and hit a magic ‘Go’ button that retrieves only that data from SQL Server based on those selections, using nothing more than standard Microsoft Excel functionality and an ODBC Connection.