The client soon chokes on all the incoming data. ![]() When I hit go Power Query proceeds to try to bring back the entire dataset (filtered, but that only removes 10% of the records) before doing One of the measure columns had a bunch of null values that I want to exclude. If I group by both attribute columns, Power Query pushes down the group by SQL to the database and returns only a few records with the measures aggregated appropriately. I select two attribute columns and two measure columns. The problem that I'm having is with Power Query SQL generation using the ODBC driver. I have the option of using three different database engines - AWS Athena, AWS Redshift, or Presto. Here's my requirement - the data source has about 300M records. I'm having an issue with Power Query (both Power BI and Excel) and am casting a wide net looking for options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |