I'm relatively new to Power Query in Excel, but I think this is a simple question. My company puts sales information in a large pivot table format and it looks like it's an Analysis Services "cube." Trouble is, Excel has trouble dealing with the data loads, and I'd like to connect to the database more directly with power query. I think I've successfully created a Connection, but I can't seem to point the query editor to it. Connection:
But when I launch the editor, nothing appears?
How do I get to the "Dataload" screen where I can start transforming data?
But when I launch the editor, nothing appears?
How do I get to the "Dataload" screen where I can start transforming data?
