![]() That being said, I may build another workbook based on the text files and attempt to create some measures and perhaps morph some PPivotĪnd PQ tables together by manually copying and pasting things, I was just hoping to not do that. I'm not sure what this limitation is, but I would be surprised if there isn't some way to work around it. Since PPivot can not produce text in the values section there are some things I cannot do (or at least don't know how to do) Defining relationships will allow you to (for example) select a field from table A and another field from table B to include in yourįinal pivot table, and have Power Pivot automatically do the join behind the scenes for you since it knows how the two tables are related. However, if you do this you will need to define relationships between the tables in Power Pivot. If you load the tables separately into the Power Pivot Data Model (instead of merging them in PQ first), this should save quite a bit of I got an error saying I needed to create relationships But if you're not able to share theĭata, then doing so probably isn't necessary. You'll have to register a Power BI Community account in order to see the private messaging option. I went to your user profile, but I saw no way to contact you under "contact me". I merged them as new to createdĪ working query using the data so I can then bring in information from about 8 small excel files that I will bring into the data model. I currently have two txt files that I created a relationship between. ![]() I try to even open a query and it takes forever, like go take a nap sort of long. ![]() Please help me figure this out, as it just won't work now. I did try to make sure it wasn't loading in the background, but when I did that it then gave an error on a subsequent query. Now when I create a new query to bring some of the data together, it takes FOREVERĪnd consumed all of the resources on my computer to the point that I can't even Google how to deal with it with the workbook open. I started a new project with just slightly larger files than the ones I worked on before 1,022,000+ records that are txt files. I am using ExcelĢ019 (64Bit) with 16 Gigs of RAM. I am new to power query, and I have been testing files, loading with connection to data model, merging tables as needed, and it seemed like it was all fine, sometimes it would take 10 minutes when closing a query to reload the data. Hello and than you in advance if you can help,
0 Comments
Leave a Reply. |