Forum Discussion

AndrewWilber's avatar
AndrewWilber
Qrew Trainee
8 years ago

Has anyone figured out a way to offload data from Quickbase into PowerBI automatically?

My team is using Quickbase to enhance data on quotes and contracts.  Our company standard reporting tool (as well as data we would not offload to Quickbase) reside in PowerBI.  Does anyone know of a way today to connect Quickbase to PowerBI for data offload?  Today we are manually doing this with CSV downloads, but would love to make this a real connection.



Thank you for the help!

2 Replies

  • BradElmore's avatar
    BradElmore
    Qrew Assistant Captain
    This may be possible by using Qunect to connect Quickbase to an Excel workbook saved on OneDrive. From what I have read...you would need to setup a refresh schedule for your Excel workbook saved on OneDrive (at the excel workbook level)......and Power BI automatically checks the file, about every hour, for updates.

    http://www.qunect.com/


    https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/


    I have not tried this....


    Refreshing an Excel workbook saved on OneDrive.

    When you connect to a file on OneDrive, or SharePoint Online, your reports and dashboards will show data as it is in the file. In this case, your Excel workbook. Power BI automatically checks the file, about every hour, for updates. If you make changes to the workbook (stored in OneDrive or SharePoint Online), those changes are reflected in your dashboard and reports within an hour. You don�t need to setup refresh at all. However, if you need to see your updates in Power BI immediately, you can manually refresh the dataset by using Refresh Now. Qunect to connect to Quickbase
  • Don's avatar
    Don
    Qrew Member
    Andrew,

    Does the new Quick Base PowerBI native integration solve the issue or do you need something more robust?