▲ 0 r/PowerBI
I have a fairly large dataset (80mil +) from a SQL database that I would like to utilize direct query + aggregation table for. All my dimension tables must be in dual storage mode then. I typically generate a standard date table in Power Query, but does anyone have suggestions / resources for uploading a simple date table to a SQL database. I figure I could upload from a file but figured there might be a better solution.
u/DrCaboose96 — 16 days ago