PowerBI.tips’ Post

Excel as a data source is both really fast and highly prone to mistakes. To help avoid mistakes, I usually do the following: 1) Limit the number of users who can access the spreadsheet. 2) Password protect the sheet and lock cells I do t want touched (headers, etc.) 3) Limit copying and pasting as it may transfer cell data types and break. I find this helps, but isn't perfect. Fast is good for certain things. I avoid using Excel as a data source as much as possible, but sometimes you just need something really fast and this is a great solution.

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..

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 🙂

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

⭐ 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

Here's why you should use Power BI 👏 #MicrosoftDynamics365 #BusinessCentral #MicrosoftDynamicsExperts #Dyn365BC #msdyn365bc #microsoftreseller #PowerBI

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

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

💎 New Video 💎 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈: 𝐇𝐨𝐰 𝐭𝐨 𝐂𝐨𝐦𝐛𝐢𝐧𝐞 𝐌𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐄𝐱𝐜𝐞𝐥 𝐅𝐢𝐥𝐞𝐬 𝐢𝐧 𝐨𝐧𝐞 𝐭𝐚𝐛𝐥𝐞 What to expect: - Storage: Local Device Folder or SharePoint Online Library - Connect Folder/Library to Power BI - Prepare - Clean - Combine the table to dynamically handle future Excel files added in the Folder/Library Have fun and thanks for watching/sharing :) https://lnkd.in/etaFh9ee #microsoft #powerplatform #powerbi #excel #sharepoint