Hi @Rafal_J
Using Alteryx allows us to complete the necessary data transformations earlier in the ETL process (prior to loading into SQL DB). Therefore, when we import to PBI the data is already cleansed and transformed and very little transformation actually takes place within Power Query. That works for us and one benefit is that I can use the SQL data in its raw format elsewhere (e.g. import to Excel) without worrying about applying another layer of transformation.
When I referred to pushing the output directly into PBI, there is a Power BI Output connector tool built for Alteryx (its free but you have to download it from the gallery). This uses PBI’s Rest API to update data tables directly within the PBI published data model. You have to register Alteryx as an Azure app. Each output tool can update a single data table. I’ve not used this much, but it does have potential to help with refresh schedule limits. The only downside I can see is that in order to connect Alteryx, you first have to build your report / publish the data model.
Hope that helps
Thanks
Rob