SAP BW Dataflows

I managed to get this to work but it was not straight forward. Not sure if this is a bug of just the fact that you have to jump through a couple of hoops to configure a blank query as opposed to setting up say a dataflow based on SQL Server. That said here are the steps that I followed in order to configure a dataflow based on SAP BW. Hopefully this will be helpful to someone else. Keep in mind that this is my first attempt at this so other than successfully making the connection I have no ideas on the limitations of setting this up. 

1. Create a new dataflow in Power BI Service (*Note I created a new workspace based on the new way and not the old way). 

2. Add New Entities

3. Select Blank Query

4. Copy your M-Code from Power BI Desktop Into the Blank Query window in Power BI Service

5. Once the screen loads you're going to see a message about an error during evaluation. Click the'Options' link in the header. 

6. In the Options screen you'll notice that the on-premise data gateway defaults to (none). Click the drop down and select your on-premises data gateway (I suppose it's safe to say at this point that you need a gateway). Click OK

7. You'll notice that the same message appears about encountering an error during evaluation. In your applied steps select an item preceeding the step that your currently on (This is at least what worked for me). Once you do that hopefully you'll see a new message that tells you to specifiy how to connect with a button that allows you to enter your credentials. Click the 'edit credentials' button

8. For SAP BW I selected Basic authenticaion then I entered my username/password that I would typically use to log into sap bw sap gui. 

9. Once you have successfully entered your credentials you should be able to click on the last step within your applied steps and if all goes we'll you'll see that your data has loaded. Click 'Done'

10. Name your dataflow

11. Schedule a refresh (Just like you would do for a dataset). 

12. From within Power BI Desktop select get data and select Power BI dataflows

13. Select the dataflow that you just created

14. Create a report

15. Publish your report (I published this bad boy to my workspace) and your done. 

Again, other than succesfully creating the dataflow to pull data from SAP Datawarehouse I have to other information. Are there any limitations on the types of transformations that I can do? Are there any limitations regarding data refresh? At this point I'm just happy to have got this configured, created a report, and published the report to a workspace other than the workspace that the dataflow was created in. I'm not sure why we can't share datasets in the same manner. Or even create multiple apps from the same workspace. I also assume that at some point I'll get to the point where I need to have a premium license in order to do anything with this. That said, this appears to be a step in the right direction. Hope it helps.