Connect to Quickbase

[alexbe]

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

[yardage]

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]

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 ? 

[yardage]

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!

[Anonymous · Accepted solution]

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