Forum Discussion
Helper IIICreate new records from keyword list
You can link to a cloud file using e.g. Dropbox/Google Drive/SharePoint/OneDrive. Make sure the file doesn't contain any sensitive data before you make it public.
Helper IIIThank you again AlexisOlson - even with the buffering I'm finding Power Query too slow to work with on this query. The query works but takes hours and hours to run, and then hours to load. I'm going to try just using DAX which I'm more comfortable writing. I also might try doing it in Python which I just started dabbling in. I really appreciate your help with M.
Super UserHmm. That's too bad. I'm pretty sure I can get it to work efficiently in Power Query but I'd need an example file to test against.
- UBComma
How can I send you a test file?
- AlexisOlson
You can link to a cloud file using e.g. Dropbox/Google Drive/SharePoint/OneDrive. Make sure the file doesn't contain any sensitive data before you make it public.
- AlexisOlson
Here's an example test file that is really slow without buffering but fast with buffering.
Original source of data here:
https://www.kaggle.com/datasets/vstepanenko/disaster-tweets- UBComma
Did you see the sample file I sent you via private message? I'll take a look at these that you sent.