Forum Discussion
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
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
4 Replies
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
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.
JacobI 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=1Any 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:
Hope this helps!