![]() Can I just remove all the worksheets and create my pivots based ONLY on the Data Model? Would it be quicker?.Once I have all my data in Excel, I create the Pivots, but it gets confusing, since I see both the Tables and the Queries in the Pivot Field list.At this point the file is already VERY slow.I then open the Data Model, add more columns and define the measures. ![]() ![]() Some of the queries are merged since I need to carry out the equivalent of VLOOKUP.I created 4 different queries that fetch data (3 xls files and 1 csv), carry out a lot of cleaning / sorting operations on them.Our ERP software is configured to export 4 report files to a specific location on a network drive, once a day.Let's start with a simple question: how to import the data, this is how I am going about it and these are the issues I have. I am very new to the whole PowerBi World, I depend a lot on it for our daily reporting, but I reckon I am NOT using it in the best way.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |