[bromcom] Power BI options as a Google school.

[Jaan]

Our users don't have Microsoft accounts, we are a Google school. I've always liked to look of the Power BI stuff and think it would be useful here.

 

What are our options to start using this?

 

IT do have Microsoft accounts due to our licensing requirements.

 

Thanks in Advance

[timbo343]

We are in the same boat and i've set up a MS Tenancy (it's free as a platform) for our MAT for those that need the license. I had to take over the MAT domain as some users had gone and set up MAT_DOMAIN without a tenancy.

 

Buy the license from a CSP provider (such as Phoenix Software) and apply it to your users. CSP works on a monthly subscription and we are adding the PowerBi Pro license to our MS agreement when it comes up for renewal.

 

PowerBi on CSP or MS agreement is around £1.50 per month.

Edited June 20, 2023 by timbo343

[CTIDTech]

Have you looked at Googles Data Studio - Power BI vs Google Data Studio: A Comprehensive Comparative Analysis - Learn | Hevo (hevodata.com)

[RLR]

We are in the same boat and i've set up a MS Tenancy (it's free as a platform) for our MAT for those that need the license. I had to take over the MAT domain as some users had gone and set up MAT_DOMAIN without a tenancy.

 

Buy the license from a CSP provider (such as Phoenix Software) and apply it to your users. CSP works on a monthly subscription and we are adding the PowerBi Pro license to our MS agreement when it comes up for renewal.

 

PowerBi on CSP or MS agreement is around £1.50 per month.

 

Similar to what we have done. We'be purchaed a few Power BI licenses for specific users and assigned it tp them on our MS Tenancy.

[garbage46]

As mentioned above, definitely check out Data Studio / Looker Studio. It's not are feature rich as Power BI, but they're adding new features on a regular basis. If you are a Goolge school you can control access and sharing in the same way as any other Google Doc / Sheet.

Data sources as Google Sheets can really effective, when linked to an daily scheduled MIS report output to CSV.

MIS CSV Report save output to a Google Drive share. Google Sheet with AppsScript to update content from CSV hourly/daily etc.

 

Import by filename:

function importCSVFromGoogleDrive() {

 var file = DriveApp.getFilesByName("ReportData.csv").next();
 var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
 var sheet = SpreadsheetApp.getActiveSheet();
 
 var columnToCheck = sheet.getLastRow();
 Logger.log(columnToCheck);
 if(columnToCheck > 5) {
   sheet.deleteRows(2, columnToCheck-1);
 }
 sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

 

Import by File ID

function import_htrCohortSummaryChart_Sum23() {
 var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = spreadsheet.getSheetByName("Cohort Summary Summer");
 sheet.getRange('A1').activate();
 var file = DriveApp.getFileById('foo123bar456');
 var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
 var sheet = SpreadsheetApp.getActiveSheet();
 var columnToCheck = sheet.getLastRow();
 Logger.log(columnToCheck);
 // if (columnToCheck > 5) {
 //   sheet.deleteRows(2, columnToCheck - 1);
 // }
 sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

[Damon]

As mentioned above, definitely check out Data Studio / Looker Studio. It's not are feature rich as Power BI, but they're adding new features on a regular basis. If you are a Goolge school you can control access and sharing in the same way as any other Google Doc / Sheet.

Data sources as Google Sheets can really effective, when linked to an daily scheduled MIS report output to CSV.

MIS CSV Report save output to a Google Drive share. Google Sheet with AppsScript to update content from CSV hourly/daily etc.

 

Import by filename:

function importCSVFromGoogleDrive() {

 var file = DriveApp.getFilesByName("ReportData.csv").next();
 var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
 var sheet = SpreadsheetApp.getActiveSheet();
 
 var columnToCheck = sheet.getLastRow();
 Logger.log(columnToCheck);
 if(columnToCheck > 5) {
   sheet.deleteRows(2, columnToCheck-1);
 }
 sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

 

Import by File ID

function import_htrCohortSummaryChart_Sum23() {
 var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = spreadsheet.getSheetByName("Cohort Summary Summer");
 sheet.getRange('A1').activate();
 var file = DriveApp.getFileById('foo123bar456');
 var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
 var sheet = SpreadsheetApp.getActiveSheet();
 var columnToCheck = sheet.getLastRow();
 Logger.log(columnToCheck);
 // if (columnToCheck > 5) {
 //   sheet.deleteRows(2, columnToCheck - 1);
 // }
 sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

 

Thanks for this, I thought it was a total shocker that you can't just link to CSV from Google Drive. Even the upload method just produced an error for me.

[Theblacksheep]

Odata feed not possible for looker?

[Damon]

This is for SIMS as opposed to Bromcom. Haven't tried OData as with Bromcom it just makes sense to use Power BI and incorporate into the MIS through the Power BI viewer. I linked to Looker through Arbor's connector and it brought through live report feeds. That's fine for basic data. It made me realise how limited Looker is though. The thing was just crawling the moment I tried to create a single attendance measure. I tested against some CSVs converted to google sheets and it wasn't blowing me away either. I'd hoped to create a good alternative for Google Schools but I'm sticking to Power BI. Hope someone has more success than me!

[NotSoFast]

Thanks for this, I thought it was a total shocker that you can't just link to CSV from Google Drive. Even the upload method just produced an error for me.

I just upload our SIMS CSV files to Drive every night using GAM with a scheduled task. It works flawlessly. I wish I could find a way to do the same with OneDrive and Power BI!

[thimon]

I just upload our SIMS CSV files to Drive every night using GAM with a scheduled task. It works flawlessly. I wish I could find a way to do the same with OneDrive and Power BI!

 

Try Power BI Gateway, allows onsite files to be seen online for Power BI, Power automate, etc. Might be what you’re after? Is what I’ve setup.

[Marci]

I just upload our SIMS CSV files to Drive every night using GAM with a scheduled task. It works flawlessly. I wish I could find a way to do the same with OneDrive and Power BI!

Easiest method is a scheduled emailer to send the report's CSV by email. PowerAutomate Online then picks up attachment by Subject Line and saves from inbox to OneDrive (or Teams folder, or Sharepoint library) then deletes the email. PowerBI picks up using the "From Sharepoint Folder" connector (which works with both OneDrive and Sharepoint paths).

[Jaan]

How does the shared account work in Bromcom?

 

Anybody using this?

 

 

[BromcomOT]

Hi Jaan,

 

This is an article which explains a little more about PowerBI setup. It goes through the difference between the two accounts too. Hope it's helpful. https://docs.bromcom.com/knowledge-base/how-to-share-power-bi-reports-in-mat-vision/

 

Thanks

[Jaan]

That's great thanks i'll take a look