If you'd like to bring Power BI data into Geckoboard, we recommend that you export your reports to Excel and connect the resulting spreadsheet to Geckoboard to display your data.
Please note that the exact steps and options may vary from what is outlined below, depending on your Power BI and Excel versions.
Display Power BI data in Geckoboard
Connect Power BI to Excel: In Power BI, you can connect to your data source and create a report or dashboard.
From the File menu, select Export, then Analyze in Excel.
Set up automatic refresh in Power BI: Power BI offers a feature called Scheduled Refresh that allows you to automatically refresh the data in your report or dashboard at specific intervals.
To enable this, go to the Dataset settings in Power BI.
Navigate to the Scheduled Refresh section and configure the refresh frequency to every 15 minutes.
Save the Excel file to OneDrive or SharePoint: To ensure easy access and collaboration, open the Excel file and save it to OneDrive or SharePoint. These cloud storage platforms allow automatic syncing and can be accessed from multiple devices.
Build visualizations from your data in Geckoboard: With the Excel file stored in OneDrive or SharePoint, you can use Geckoboard's Spreadsheets data source to connect with these services and bring the the Power BI data into Geckoboard.
Learn how to connect to OneDrive for Business.
Or, learn how to connect to Sharepoint.
Configure the spreadsheet data to refresh automatically with Power Automate: To ensure the data in your Excel file refreshes without having to open the file, you can set up a script using Power Automate.
While still viewing your Excel file, create the script by going to Automate > All Scripts > New Script.
Then, add the following script:
function main(workbook: ExcelScript.Workbook) {
let worksheet = workbook.getWorksheet("Sheet1");
// Get the cells at A1 and B1.
let dateRange = worksheet.getRange("A1");
let timeRange = worksheet.getRange("B1");
// Get the current date and time using the JavaScript Date object.
let date = new Date(Date.now());
// Add the date string to A1.
dateRange.setValue(date.toLocaleDateString());
// Add the time string to B1.
timeRange.setValue(date.toLocaleTimeString());
}The script above enters the current date and time into cells A1 and A2, forcing the spreadsheet to refresh. You can change the sheet name and destination cells as required.
Using Power Automate, create a new flow to automate the script.
In the first step, set the refresh interval.
In the second step, select your Excel file and the script you created earlier.
Save the flow.