Hi! Me again!
I’ve understood the original way to pull data. I’ve successfully created several views and imported them to Power BI. Yay!
However, now I’m running into a speed problem. I’m trying to pull just the raw data in, so for example I use Select * from user_visits/users/topics, etc. I also have several forums. Currently I’m testing with about 15, but the refresh has started getting way too long, for example with User Visits. I’m currently sitting on an refresh for the past hour, for example. I’m eventually going to be importing data from hundreds of forums, so obviously that won’t work in the long term.
I’m truly lost with your work around though. I tried adjusting it, but it didn’t work (mainly because I’m rather poor at writing SQL queries). Can you help me in reworking your work around to allow me to say get Select * From User_visits in a quicker way?