cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alexbe
Frequent Visitor

Connect to Quickbase

Hi Team,

 

I'm trying to connect to a QuickBase application via AIP call. I know I'm supposed to paste the token somewhere in the URL but I'm a bit lost and not able to sign in.

 

Previously there was a very helpful article under this link which worked great but is not available anymore 

https://quickbase.skilljar.com/setting-up-microsoft-power-bi-with-quick-base-as-the-dataset/91866

 

Anybody knows how to do it?

 

Thanks,

Alex

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @alexbe,

 

Please refer to below links about invoke api through web connector with xml contents.

Understanding the API call reference

POST http(s) request with xml content in Power Query

Web Services And POST Requests In Power Query

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
yardage
Regular Visitor

Hi Alex,

 

Do you have access to Quick Base University? I just presented this at our annual conference, and the method for doing this is in there:

 

Quick Base and PowerBI - Better Together - (you can skip to around minute 19 to get right to it)

 

Let me know if you need additional information.


Jacob

Anonymous
Not applicable

I am trying to connect within powerBi.. I create a blank query and paste this in

 

= Csv.Document(Web.Contents("https://ga.quickbase.com
/db/bitfp9mn2?a=API_GenResultsTable&options=csv&qid=1",
[Content=Text.ToBinary("usertoken=b36sn5_ump_bk5kydsdgrx3d3bejw5m8cxyzxyz")]))

 

And I get

 

DataFormat.Error: Invalid URI: The hostname could not be parsed.
Details:
https://ga.quickbase.com
/db/bitfp9mn2?a=API_GenResultsTable&options=csv&qid=1

 

Any idea ? 

The newest version of PowerBI (Feb '19) now includes a native connector to Quick Base. You may need to clear your current connection via the steps here:

 

https://www.c-sharpcorner.com/article/edit-or-remove-permission-from-existing-data-source-connection...

 

Hope this helps!

v-shex-msft
Community Support
Community Support

Hi @alexbe,

 

Please refer to below links about invoke api through web connector with xml contents.

Understanding the API call reference

POST http(s) request with xml content in Power Query

Web Services And POST Requests In Power Query

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors