Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

Power BI and Alteryx Connect

Inactive User
Not applicable

We are early in our implementation of both Power BI and Alteryx Connect (along with Alteryx Server as well).

 

We are working to build a data abstraction layer in Spring/Spring Cloud that would expose data sources across our hybrid-cloud environment (on-premise, AWS, Azure, SaaS APIs) and take advantage of the Connect SDK to register these services within Alteryx Connect to make them discoverable to our users.  We've standardized on Power BI as our visualization tool for wider enterprise use with Designer in the hands of the more citizen data scientist, advanced analytics users.  Spring will take care of the hard core data engineering and data science workloads that will remain the purview of the data science and IT teams.

 

I've found great documentation on how to import the metadata from Power BI into Connect which is very helpful.  This documentation supports only one direction of data flow into Connect.  I've not been able to find how I would expose the data sources registered in Connect to Power BI for selection and use.  Is there documentation and/or an API for interrogating the information stored in Connect?

 

Thank you!

 

Kevin

4 REPLIES 4
OndrejC
Alteryx
Alteryx

Hi @Inactive User ,

you are probably looking for our Connect REST API Documentation which will allow you to get metadata out of Connect:

https://help.alteryx.com/connect/RESTAPIdocumentation/index.html

 

hope this helps,

Ondrej

Connect Team

 

Inactive User
Not applicable

Thank you for your response, @OndrejC .

 

I had found the same documentation, but it doesn't seem to contain the details I'm looking to learn.  Is there a legend for the entry types that are available?  I've not found any information that details out what is available to access via the API.  There are only 4 entries in that documentation, two of which are login and logout.

OndrejC
Alteryx
Alteryx

hi @Inactive User ,

 

Login & logout are pretty clear what they do.

 

Lucene - in this endpoint you can write lucene queries to Connect (lucene is search engine behind that), and based on what are you looking for you get the list of entries (xid, name, attributes).

 

In order to understand the query (parameters & format) you can go to Connect - click on search - choose Advanced search and start choosing some filters e.g. entry type: table. If you click on "view query" you can see actual query which was generated, this query can be used on endpoint (type:table). See screenshot.

Screenshot 2019-03-06 at 16.38.29.png

 

 

 

Entry - this endpoint returns detail on individual entry (based on xid)

 

hope this helps,

Ondrej

Connect Team

Inactive User
Not applicable

@OndrejC, outstanding.  That makes it much clearer!