Automating reports from Alteryx Gallery (Server) to Power Bi

[PammyC]

Has anyone successfully managed to connect Alteryx workflows on their reporting gallery/server to Power Bi dashboards to do an automated refresh?  

We have a series of Alteryx Workflows that are scheduled daily to run from different systems and a set of Power Bi dashboards designed and shared, but we're struggling to automate the process between the two.  Ideally the workflows would run overnight and the Power Bi dashboards would refresh with the new data, but we can't seem to get the Power Bi connector to work.  We can refresh the dashboards manually, but we can't work out how to automate the process.  

Has anyone cracked it and how? 

[AHill06]

Hi PammyC, 

Did you managed to get this resolved. this is something i think we would like to implement if its possible. 

Thanks 

[Deano478]

@PammyC are the reports on PowerBi service or are you just using the desktop version of PBI?

[AHill06]

@Deano478  The reports I'm trying to refresh are within a workspace on the PowerBi Service. 

[Deano478]

@AHill06 if they are already on the service then why not just let the Alteryx flows run to update the backend data then use the Scheduled Refresh on PowerBi Service to refresh the data?

[AHill06]

@Deano478 we are currently going down this route. however we are not always certain how long the alteryx workflow will take, it will depend on the input which could be rather small to millions of records, which means the length of time for the workflow to finish will vary. so we need to be careful we dont schedule the refresh when the workflow is still running and at the same time schedule it too slowly so that the workflow has finished and yet the power bi refresh doesnt happen for hours afterwards. hence why it would be nice for alteryx to refresh powerBi when its finished

[Deano478]

@AHill06 The only way I've ever done a refresh with Alteryx was by chaining two power automate flows together one to run the alteryx flow and another flow to refresh the dashboard when the previous flow has finished but I cant imagine your Alteryx runtime could vary that you and you team should be able to give a very good educated guess as to when to schedule a refresh in the service as I think you can set it to refresh 6 times a day

[AHill06]

No afraid not, if you find out how please do let me know.

the best we could do was to schedule the job to refresh on the PowerBL side, which isn't ideal as it can be hours after the data is ready. shame you cant get Alteryx to trigger the refresh.