Unless you are accessing SSAS tabular data, you should always use Power Query to import your data.
What if I do nOT use the PowerQuery but instead import the data straight from the Data Model? Is it cleaner / simpler?. 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 kommentar(er)
