Forum Discussion
14 Replies
Sort By
- ArchiveUserQrew CaptainHere is a complete URL that will retrieve an entire table of data. Just replace the 5 variables that start with "YOUR" with your information and paste the entire string into the URL box in Power BI:
https://YOUR_DOMAIN.quickbase.com/db/YOUR_TABLE_ID?a=API_GenResultsTable&apptoken=YOUR_APP_TOKEN&ticket=API_Authenticate&username=YOUR_USERNAME&password=YOUR_PASSWORD
Note: While this will work, it is not the most secure. Your credentials are stored in plain text. - txtMoviestxtMovQrew MemberI'll give it a try. Thanks.
- Claudevon_RoesgQrew MemberPlease download the latest version of QuNect ODBC for QuickBase to get connectivity with Power BI.
https://qunectllc.com/download/QuNect.exe
Please call if you have any questions:
978-405-2524 - Claudevon_RoesgQrew MemberJust discovered that if you have two or more relationships to the same parent table then PowerBI chokes if you try to use the application/table chooser UI. Instead you'll need to use advanced options. Please watch the following video to see an example of how to do this. http://qunect.com/appnotes/PowerBI.html