Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.