How to generate a graph without using Dashboard?

My business is attempting to transition to using Hue for data aggregation and analysis, and I need to generate graphs based on data stored in the SQL server. Although I know the Dashboard is Hue’s preferred method of graph generation, I attempted to load my data into a Collection and encountered a permissions error, so I think I need to do it another way. Does anyone know how I can accomplish this or have any tips?