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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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!
Photo of Andrew

Andrew

  • 50 Points

Posted 2 years ago

  • 0
  • 1
Photo of rocketc

rocketc

  • 694 Points 500 badge 2x thumb
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