I’m new to Power BI and I’ve never used SQL. I have a couple quick questions I thought you might be able to answer.
SQL - Do you have any recommendations for learning SQL? I honestly don’t know where to start.
Power BI - My IT group helped me connect via ODBC to our ERP directly but it takes forever to pull from it (any change in Transform causes Power BI to recalculate for what seems like every row in the table). Is it better/possible to pull down ERP table to SQL then have Power BI access SQL? Again, I don’t even have the SQL program so this might not be the right way to think about it. You mentioned you think in SQL so I’m sure you can correct me.
Thanks in advance.