Will Elnick’s Post

Excel loaded to Power BI is really easy ... but also easy to mess up. Reasons my report has broken from Excel: -Text in Numerically formatted Columns -Whole new format of data -Column order rearranged -Changed Column names -Duplicate ID values -Removed Columns -Tables moved -Empty rows But sometimes it's inevitable, And Excel just happens to fit the needs. 2 ways to prevent Excel breaking your Power Bi report as often: - Don't use Excel, use dynamics or sharepoint lists (similar but more controlled) - Protect the cells (like header names) so they can't be altered. Do you do a lot of Power BI reports connected to Excel? #PowerBI #DataAnalyst #BusinessIntelligence

Well, it seems to me that the best 2 ways to prevent “Excel breaking Power BI report” should be: 1) First and foremost, education! Anyone involved in preparing dates should understand what is required. So, all of them should receive training. I’m not just talking about users preparing data in Excel. Because, in my experience, the deficiencies you are talking about (Changed Column names, Text in numerically formatted columns) occur even in the data provided by management systems - 2)     Prevent breaks in Power Query as much as possible. for example: -to prevent breaks caused by empty rows, we could insert the remove blank rows step even if there are none when you prepare the model -to prevent breaks caused by removed Column or by whole new format of data, it is a good practice avoid any unnecessary applied step (such as changed type, reordered columns, renamed columns) that use column names -… By the way, Column order rearranged is NEVER a problem 🙂

Epic scenario:d client escalation/ lots of email from client /lots of follow-up from management... after investigation developer come to know below reason for report break..

⭐ NEW Power BI Feature: Visual Calculations - What are Visual Calculations? - Visual Calculations allow users to create new calculations on a visual, using a simple interface based on a table of data, supported by powerful, easy to use formulas and Excel-like capabilities. Check out the documentation here: https://lnkd.in/ez5Ra_Uk Check out the presentation from Jeroen (Jay) ter Heerdt and Reid Havens 🧙🏻♂️ von Havens Consulting Inc.: https://lnkd.in/eifUZ367 Follow me for more similar updates and definitely follow the people mentioned above to not miss the latest and greatest updates! #microsoft #powerplatform #powerbi #update #feature

In PowerBI, perform a bulk find and replace of multiple comma separated items in a cell https://lnkd.in/g8qeMAri #powerbidesktop #powerbi #powerquery #microsoftexcel #msexcel #excel

New video this week - how to get premium #Planner data into Power BI or Excel! This lets you report on projects for your whole organization or team together in a single place, which has traditionally been a bit of a challenge in Microsoft 365. Spoiler - the flavor of Planner we're looking at here is based in #Dataverse, so you can use the Dataverse connector to access it. I'll put a link to the video in the comments. There's a comparison of the different Planner options in the intro too. 😄

With the May 2024 release of Power BI, we finally get some improvements for the Matrix visual, where the layout and formatting options now resembles the look and feel of an Excel pivot table. It’s now possible to repeat row headers, insert blank rows, and select from compact, outline and tabular layouts. Another feature I personally like is that you can create folders in a workspace to have a hierarchical structure for organizing and managing items in the workspace. As from this new release you can now from the desktop application publish your semantic models and reports to a dedicated folder in the workspace😊 Read more about the May 2024 release in this Microsoft blog https://lnkd.in/gskU9snn #powerbi

Excited to dive into Power BI Desktop but feeling overwhelmed? Good news! If you’re familiar with Microsoft Excel and/or Microsoft PowerPoint already, then most of the actual point and clicking will be done in a very similar way. These are the five steps to create your first report: 📥 Download Power BI Desktop 🔗 Connect to Your Data 🧹 Clean, Shape, and Transform Your Data 🏗️ Build Your Report 💬 Share and Collaborate In Robby White’s latest blog post, he goes through those five steps to show you exactly what to do when creating your Power BI Desktop report. Check it out below. ⤵ https://lnkd.in/dM9tBxqS

Hi LinkedIn fam! Just discovered a secret of M code in POWER BI and Power Query - simply type =#shared to access a list of almost 900+ functions covering text, dates, and more. No need to remember them all anymore! This trick also works in Excel. How interesting! 😃 #POWERBI #PowerQuery #ExcelTricks

Are you spending too much time manipulating data instead of running your business? It's a common problem for growing companies. But with Power BI, you can simplify the process and focus on what really matters. Here's how: 1. Identify all your raw data sources. 2. Save the data to a SharePoint folder. 3. Connect your data to Power BI. 4. Create a data model. 5. Use DAX to recreate your calculations (similar to Excel formulas). With this approach, you can easily update your SharePoint files with fresh data and refresh your Power BI reports each day, week, or month. #PowerBI #DataAnalysis #BusinessGrowth