DATA ANALYSIS POSTING

  This magic trick is to export your data sets to excel as a data model, not a table so it can hold millions of rows. sol let's go over this step by step. Open your Power BI file and a new Excel File Then Power Pivot is an add-in that you can use to perform powerful data analysis in Excel. Here’s how you enable Power Pivot before using it for the first time. Go to File > Options > Add-Ins. In the Manage box, click COM Add-ins> Go. Check the Microsoft Office Power Pivot box, and then click OK. To get this magic address, from your Power BI file open Dax studio and see the next screenshot In the right lower corner you can see our magic address Follow this link to see how to connect Dax studio to Power BI Here's your data you can easily load it to your data model You can also do the same using power query instead of power pivot  Regards.

Well this usually happens as you are hitting 'Combine & Transform' Letting Power BI doing all the work  well, Don't do this again! Have you ever got this annoying error when importing data from a folder on Power BI or Excel? Here's the best way to do it: 1- Click 'Transform Data' Instead Of 'Combine & Transform' This will let you do all the work from the start, don't be afraid it is so easy 2- Step By Step  1- That's our contents 2- We don't need the other information right now 3- Let's add a custom column 4- This is our magic word that will extract our data nice and good  5- That's our main column so rewove the others 6- Extract the sheets and tables within our excel files 7- That's an important note : you will have this if your data is in tables within your files  the editor reads it twice, once as a sheet and once as a table so you will have to only select one of them 8- Now after filtering to only tables we only want t...

It's a sneaky way to get around coding and using visual studio to create a link between a folder and SQL server but it is as efficient as it can be! The main idea is using Power BI's Query Editor to do all the boring work of merging data from multiple excel files for us into one table -also you can wrangle your data however you want- then exporting it using Dax Studio, So let's dig into it. 1- You Will Obviously Have To Download Dax Studio   It is a free 8MBs tool that can be easily downloaded from here:  DAX Studio - The ultimate client tool for working with DAX queries It's easy to install so I'm not gonna explain it to you, sorry. 2- Have A Look On The Data   So this is our data,  It's a folder containing multiple  excel files from which  we want to extract our data and merge it. It can be as many as it is  3- Open The Good Power BI And Get Data 1- Open Power BI 2- Click on 'get data' 3- Select data from 'folder' 4- Select your desired f...