Nayan Patel

My feedback

  1. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  2. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  3. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has announced Generic SOAP / REST API connector which you can use to pull data from WorkDay SOAP Web Service in Power BI or other ODBC tools. Check below link https://zappysys.com/blog/connect-workday-power-bi-import-soap-data/

    Here is sample SQL query

    SELECT * FROM $
    /*Below WITH clause is optional, uncomment parameter(s) values you like to set
    which are different than DSN properties.
    */
    WITH(
    Src='https://xxxxxxxxxx.workday.com/ccx/service/yyyyyyyyy/Human_Resources';
    --,ElementsToTreatAsArray='wd:Worker'
    --,DataConnectionType='HTTP'
    --,SoapWssPasswordType='PasswordDigest'
    --,UserName='testuser001'
    --,CredentialType='SoapWss'
    --,Filter='$.env:Envelope.env:Body.wd:Get_Workers_Response.wd:Response_Data.wd:Worker[*]'
    --,RequestContentTypeCode='TextXmlUtf8'
    --,RequestMethod='POST'
    --,Header='SOAPAction: ""'
    ,RequestData='
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/&quot; xmlns:bsvc="urn:com.workday/bsvc">
    <soapenv:Header/>
    <soapenv:Body>
    .......... .......... ..........
    .......... FROM SOAPUI .........
    .......... .......... ..........
    </soapenv:Body>
    </soapenv:Envelope>'
    )

  4. 393 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    backlog  ·  57 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has announced Generic SOAP / REST API connector which you can use to pull data from WorkDay SOAP Web Service in Power BI or other ODBC tools. Check below link https://zappysys.com/blog/connect-workday-power-bi-import-soap-data/

    Here is sample SQL query

    SELECT * FROM $
    /*Below WITH clause is optional, uncomment parameter(s) values you like to set
    which are different than DSN properties.
    */
    WITH(
    Src='https://xxxxxxxxxx.workday.com/ccx/service/yyyyyyyyy/Human_Resources';
    --,ElementsToTreatAsArray='wd:Worker'
    --,DataConnectionType='HTTP'
    --,SoapWssPasswordType='PasswordDigest'
    --,UserName='testuser001'
    --,CredentialType='SoapWss'
    --,Filter='$.env:Envelope.env:Body.wd:Get_Workers_Response.wd:Response_Data.wd:Worker[*]'
    --,RequestContentTypeCode='TextXmlUtf8'
    --,RequestMethod='POST'
    --,Header='SOAPAction: ""'
    ,RequestData='
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/&quot; xmlns:bsvc="urn:com.workday/bsvc">
    <soapenv:Header/>
    <soapenv:Body>
    .......... .......... ..........
    .......... FROM SOAPUI .........
    .......... .......... ..........
    </soapenv:Body>
    </soapenv:Envelope>'
    )

    Nayan Patel commented  · 

    Workday API is XML SOAP Service. ZappySys has created an easy to use ODBC drivers for REST / SOAP API access so you just write SQL queries to access data in any ODBC compliant apps (e.g. Power BI, Tableau, Qlik, SSRS).

    Please refer this article to learn how to call SOAP API (e.g. Workday API) in Power BI
    https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/

    Hope this helps!

  5. 63 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has Amazon MWS connector which allows you to query using SQL language and import MWS data to Power BI / other apps (excel, SSRS, SQL Server). See below link.

    https://zappysys.com/blog/import-amazon-mws-data-power-bi/

  6. 34 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has released Drivers for REST API (JSON / XML / SOAP). Using these drivers you can connect to virtually any API service in Power BI. It comes with many advanced options such as OAuth, Pagination, Error Handling , Query Editor and many more. See below links.

    https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

    https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/

  7. 300 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has released Drivers for REST API (JSON / XML / SOAP). Using these drivers you can connect to virtually any API service in Power BI. It comes with many advanced options such as OAuth Token, Pagination, Error Handling , Query Editor and many more. See below links.

    https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
    https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/

    For some concepts of reading Office 365 data (OData API) check this Blog. Its written for SSIS but UI and Settings are same for REST API Driver.

    https://zappysys.com/blog/calling-office-365-api-using-ssis-graph-api-mail-calendar-contacts-onedrive-excel/

    Hope this helps!

  8. 79 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has released Drivers for REST API (JSON / XML / SOAP). Using these drivers you can connect to virtually any API service in Power BI. It comes with many advanced options such as OAuth Token, Pagination, Error Handling , Query Editor and many more. See below links.

    https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
    https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/

    Hope this helps!

  9. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has released Drivers for REST API (JSON / XML / SOAP). Using these drivers you can connect to virtually any API service in Power BI. It comes with many advanced options such as OAuth, Pagination, Error Handling , Query Editor and many more. See below links.

    https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
    https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/

  10. 130 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has ODBC Driver for XML/JSON API which can be used to pull data directly from AWS S3 or other AWS API (e.g. Athena, EC2, Billing API). See below Post

    https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/

  11. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has ODBC Driver for XML/JSON API which can be used to pull data directly from AWS S3 or other AWS API (e.g. Athena, EC2, Billing API). See below Post

    https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/

  12. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has ODBC Driver for XML/JSON API which can be used to pull data directly from AWS S3 or other AWS API (e.g. Athena, EC2, Billing API). See below Post

    https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/

  13. 80 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Nayan Patel commented  · 

    ZappySys has ODBC Driver for XML/JSON API which can be used to pull data directly from AWS S3 or other AWS API (e.g. Athena, EC2, Billing API). See below Post

    https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.