4 ms·

Would you share the ones you found worthwhile? Our business wants PowerBI, but the sys admin side sounds like a pain : it seems we need: 1) a consultant to set

Would you share the ones you found worthwhile? Our business wants PowerBI, but the sys admin side sounds like a pain : it seems we need: 1) a consultant to setup the visualisations 2) either a vm running windows server or create a db on azure to update manually because powerbi doesn't allow aws databases 3) the api automation capabilities are unclear says the expert (eg: create a new dashboard for a new customer ? Update all the visualisations through a script? Etc) PowerBI feels so Microsoftish, I'm really on the market for something else

mjirv 8y ago
Looker's API functionality is pretty extensive if that's something you care a lot about.
mbesto 8y ago
PowerBI is really an amazing for the price point (free-ish for O365 accounts) for most businesses out there (10~300 employees). It's not one size fits all and YMMV. 1) You have this problem regardless 2) Huh? Why not just the cloud version? Are you trying to report directly on a productive transactional database for a software app? See #3 about source of data. 3) Depends on your source data. I build a dashboard for sales in with data from SalesForce in like 2 hours.
go_prodev 8y ago
I'm currently helping a large company with their transition from Tableau/SAP/Excel to Power BI. The adoption has been extremely painless and business users are very comfortable creating reports and discovering new ways to represent their data. In response to your points above... 1) A consultant is not required to set up visualisations. With minimal training (a few hours) most users understand the fundamentals and are ready to go. 2) We use AWS Redshift. You have the option to import data into Power BI or do a direct query from the cloud platform to Redshift with odbc. 3) what are you trying to do with the API? To automate reports you normally set up a gateway connection to your data source and schedule the refresh in powerbi cloud. No API required normally. It also can use office 365 or Azure AD for single sign on, making sys admin activities a breeze. Send me a message if you want to discuss anything specific and I'd be happy to help you out.
- feydaykyn 8y ago
  Our business users already hired the consultant and I'm trying to make sense of his answers, but he does seem to be knowledgeable only on using a mouse. We want to create a template dashboard of visualisations, which would be duplicated for each of our customers, each one having its own data source and workspace. New customer creation should be automated through API calls and we would prefer centralize our resources on AWS. That's it. The consultant has been so fuzzy that it seemed utterly complex to set-up, but by reading all the answers things are starting to make sense. Redshift would be great, thanks for the pointer!
cosmie 8y ago
> 2) either a vm running windows server or create a db on azure to update manually because powerbi doesn't allow aws databases I believe this is a misunderstanding. You can totally connect to AWS databases with PowerBI, assuming your AWS database is routable. You can't set up the connection through the web interface, but you can use PowerBI Desktop to set up virtually any database that has an ODBC driver as a source[1]. And once you publish it to the Azure-hosted PowerBI instance, it'll use that connection string to connect directly to the data source and automatically update/refresh like any other data source. As for a VM running Windows Server - that's the option if your AWS database isn't routable by the Azure-hosted PowerBI service. You install a gateway for PowerBI to hop through, and configure all of the data sources within that gateway. That way your internal AWS databases are not publicly routable, and you can lock down and centralize the connection between PowerBI and AWS via that gateway box[2]. Data Gateway is a Windows-only application at the moment, so that part is a pain. But it's a relatively minor pain in the grand scheme of BI implementations. [1] https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-data https://docs.microsoft.com/en-us/power-bi/desktop-connect-to... [2] https://docs.microsoft.com/en-us/power-bi/service-gateway-getting-started https://docs.microsoft.com/en-us/power-bi/service-gateway-ge...
- feydaykyn 8y ago
  Yes exactly, so the only way to have a non public database is to run a Windows vm on AWS, I would rather avoid that, especially because we need one vm per customer. Thanks for the detailed write up!
  - cosmie 8y ago
    Is there a reason you need one VM per customer, and can't use a single Data Gateway to manage multiple data connections? On that note, you don't have to use the official data gateway application. It certainly has a lot of ancillary benefits, but isn't critical. You can just as effectively create a bastion linux host and use ssh to remote forward the connection to AWS database[1]. I've done that plenty of times in the past, to access databases like Redshift and Dynamo that were within non-public VPCs. Easier to manage and cheaper to run per client, if that's a hard requirement. You could also use something like QuickSight, if you're purely AWS. But I'd only recommend that if you expect to allocate a large amount of development resources for support. PowerBI is a lot more user friendly for business users to be self-sufficient, and sometimes it's less of a hassle to deal with the up-front complexity of that than to deal with the non-stop application support needs of business users. [1] https://www.ssh.com/ssh/tunneling/example#sec-Remote-Forwarding https://www.ssh.com/ssh/tunneling/example#sec-Remote-Forward...
kthejoker2 8y ago
1) nope, it's a 100% self service tool, no outside assistance needed. 2) PowerBI uses AWS just fine, you may need a gateway depending on how you expose your AWS DB for external access, but that'd be true of any tool connecting to it. 3) why an expert? Here's the API spec, it's not hiding ... https://docs.microsoft.com/en-us/rest/api/power-bi/ https://docs.microsoft.com/en-us/rest/api/power-bi/
- feydaykyn 8y ago
  Many thanks for the API link, the expert was completely unclear on what may be possible on the automation side (full api configuration without using a mouse).

mjirv 8y ago

Looker's API functionality is pretty extensive if that's something you care a lot about.

mbesto 8y ago

PowerBI is really an amazing for the price point (free-ish for O365 accounts) for most businesses out there (10~300 employees). It's not one size fits all and YMMV. 1) You have this problem regardless 2) Huh? Why not just the cloud version? Are you trying to report directly on a productive transactional database for a software app? See #3 about source of data. 3) Depends on your source data. I build a dashboard for sales in with data from SalesForce in like 2 hours.

go_prodev 8y ago

I'm currently helping a large company with their transition from Tableau/SAP/Excel to Power BI. The adoption has been extremely painless and business users are very comfortable creating reports and discovering new ways to represent their data. In response to your points above... 1) A consultant is not required to set up visualisations. With minimal training (a few hours) most users understand the fundamentals and are ready to go. 2) We use AWS Redshift. You have the option to import data into Power BI or do a direct query from the cloud platform to Redshift with odbc. 3) what are you trying to do with the API? To automate reports you normally set up a gateway connection to your data source and schedule the refresh in powerbi cloud. No API required normally. It also can use office 365 or Azure AD for single sign on, making sys admin activities a breeze. Send me a message if you want to discuss anything specific and I'd be happy to help you out.

feydaykyn 8y ago
Our business users already hired the consultant and I'm trying to make sense of his answers, but he does seem to be knowledgeable only on using a mouse. We want to create a template dashboard of visualisations, which would be duplicated for each of our customers, each one having its own data source and workspace. New customer creation should be automated through API calls and we would prefer centralize our resources on AWS. That's it. The consultant has been so fuzzy that it seemed utterly complex to set-up, but by reading all the answers things are starting to make sense. Redshift would be great, thanks for the pointer!

cosmie 8y ago

> 2) either a vm running windows server or create a db on azure to update manually because powerbi doesn't allow aws databases I believe this is a misunderstanding. You can totally connect to AWS databases with PowerBI, assuming your AWS database is routable. You can't set up the connection through the web interface, but you can use PowerBI Desktop to set up virtually any database that has an ODBC driver as a source[1]. And once you publish it to the Azure-hosted PowerBI instance, it'll use that connection string to connect directly to the data source and automatically update/refresh like any other data source. As for a VM running Windows Server - that's the option if your AWS database isn't routable by the Azure-hosted PowerBI service. You install a gateway for PowerBI to hop through, and configure all of the data sources within that gateway. That way your internal AWS databases are not publicly routable, and you can lock down and centralize the connection between PowerBI and AWS via that gateway box[2]. Data Gateway is a Windows-only application at the moment, so that part is a pain. But it's a relatively minor pain in the grand scheme of BI implementations. [1] https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-data https://docs.microsoft.com/en-us/power-bi/desktop-connect-to... [2] https://docs.microsoft.com/en-us/power-bi/service-gateway-getting-started https://docs.microsoft.com/en-us/power-bi/service-gateway-ge...

feydaykyn 8y ago
Yes exactly, so the only way to have a non public database is to run a Windows vm on AWS, I would rather avoid that, especially because we need one vm per customer. Thanks for the detailed write up!
- cosmie 8y ago
  Is there a reason you need one VM per customer, and can't use a single Data Gateway to manage multiple data connections? On that note, you don't have to use the official data gateway application. It certainly has a lot of ancillary benefits, but isn't critical. You can just as effectively create a bastion linux host and use ssh to remote forward the connection to AWS database[1]. I've done that plenty of times in the past, to access databases like Redshift and Dynamo that were within non-public VPCs. Easier to manage and cheaper to run per client, if that's a hard requirement. You could also use something like QuickSight, if you're purely AWS. But I'd only recommend that if you expect to allocate a large amount of development resources for support. PowerBI is a lot more user friendly for business users to be self-sufficient, and sometimes it's less of a hassle to deal with the up-front complexity of that than to deal with the non-stop application support needs of business users. [1] https://www.ssh.com/ssh/tunneling/example#sec-Remote-Forwarding https://www.ssh.com/ssh/tunneling/example#sec-Remote-Forward...

kthejoker2 8y ago

1) nope, it's a 100% self service tool, no outside assistance needed. 2) PowerBI uses AWS just fine, you may need a gateway depending on how you expose your AWS DB for external access, but that'd be true of any tool connecting to it. 3) why an expert? Here's the API spec, it's not hiding ... https://docs.microsoft.com/en-us/rest/api/power-bi/ https://docs.microsoft.com/en-us/rest/api/power-bi/

feydaykyn 8y ago
Many thanks for the API link, the expert was completely unclear on what may be possible on the automation side (full api configuration without using a mouse).