Workato Data Table(s) as data source in PowerBI?

[RussellJ]

Hi

I'm using Data Tables to cache data whilst integrating two systems, in order to both reduce the number of API calls I'm making and also to provide an audit trail of actions being made, to help out whoever has to support the delivered solution in future.

It occurs to me it might be quite simple to able to create a PowerBI report which uses the content of one or more of the Data Tables as the source in order for end users/support staff to be able to view/troubleshoot the integration.

Is it possible to use one or more Workato Data Tables as a data source in PowerBI? I can see a connector in Workato, but I don't want to reach OUT to PowerBI (e.g. to add data or do things to a report), but rather want PowerBI to be able to consume data in a Data Table.  I guess it's a config at the PowerBI end, but just curious as to whether its possible.

Thanks in advance

Russell

[rajeshjanapati]

Hi @RussellJ,
I don't have much idea on Power BI integration with Workato, but there is a way to combine the data from different Workato DataTables (irrespective of count) with the help of SQL Transformation by Workato application and in that
1. First select all the required Workato DataTables as data sources in the Input of the SQL application
2. Write a query to combine all the records
3. as per PowerBI input acceptance, you can select the output from SQL Step as csv content stream or you can able to save as a CSV or Excel into FileStorage.
4. After saving the file into FileStorage, in another recipe, get the file contents and give them as input to the PowerBI step.
5. if PowerBI, accepts the csv content stream directly, you can able to select from SQL Step.

Hope you got my point?
Thankyou...!

[RussellJ]

Hey Rajesh!  Thanks for taking time time to reply.

I was hoping there's a native solution for this, with the Data Tables being used directly as a data source in PowerBI, rather than a workaround of bouncing the data elsewhere first.

But very much appreciated your suggestion!

Russell

[rajeshjanapati]

Hoo great then you can able to map the data directly... Thanks for the information too.