Forum Discussion

supannik's avatar
supannik
Regular Visitor
8 years ago
Solved

Get data from form builder app

Hi,

 

I am having problem getting data submitted in www.123formsbuilder.com into PBI, it shows 

 

or even when I put API keys/ username / pw, it also shows followings:

Question is how can I get data submitted in forms I build into PBI?

Thank You.

  • Update (June 5, 2018):

     

    123forms advise to sync the form with G.sheet, then have PBI connect to G.Sheet instead.

     

    Thank you all for your recommendations.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I don't know 123 Forms Builder specifically, but the connector you are using is attempting to load a webpage and scan that page for data.  If you are submitting forms, where is the data being stored?  Does 123 Forms Builder have a backend database that it stores the information?  If so, what database do they use? Do you they give you a username and password for that database?  Have they provided you with database connection information.

    • supannik's avatar
      supannik
      Regular Visitor

      they said I can connect via API Numbers which also did not work. I will check on Uname & Pw for DB then. 

      Is there any other recommendation or Question I should ask them?

      I'm business user with no programming background.

       

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable

        As them specifically about Power BI and see if they have any information about making such a connection.

         

        If they don't, ask them about what "Data Connectors" they do allow.

         

         

        If they suggest that Rest API is all that will give you access to, then you have a much more technical road to venture down.

         

        Here is an article of what you can do with Rest APIs

         

        https://msdn.microsoft.com/en-us/library/dn877544.aspx