Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Hi Stanley,
you basically have two options for this.
https://github.com/mmwebaze/powerbi_Symfony
I hope this helps.
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Hi Channara,
you create the token on Powerbi. See link below with some useful hints.
https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-with-azure-ad
Regards,
Michael
On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Hi All,
Just in case you were wondering how to link Power BI to DHIS2, see below:
Enter URL of DHIS2 analytics table in the format: dhis2-url/api/reportTables/report-ID/data.csv
Select Basic for authentication
Preview the data and load it in Power BI
Regards,
Waka Wafubwa
On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Hi All,
Just in case you were wondering how to link Power BI to DHIS2, see below:
Enter URL of DHIS2 analytics table in the format: dhis2-url/api/reportTables/report-ID/data.csv
Select Basic for authentication
Preview the data and load it in Power BI
Regards,
Waka Wafubwa
Thanks. Is a good resource.
Regards
On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Thank you sharing this.
It works fine as you guided.
On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Paul – We have been doing quite a bit of this with Power BI. The web api makes it possible to really expand analysis beyond DHIS 2’s capabilities. They complement each other very well, once you get the hang of it.
Thank you sharing this.
It works fine as you guided.
On Mon, Oct 22, 2018 at 3:10 PM Waka Wafubwa charlwak@gmail.com wrote:
Hi All,
Just in case you were wondering how to link Power BI to DHIS2, see below:
- Login to your DHIS2 instance and get the ID of your pivot table that has data you want to push to Power BI
- Open Power BI and select Get Data; Under Other, select Web then Connect
- Enter URL of DHIS2 analytics table in the format: dhis2-url/api/reportTables/report-ID/data.csv
- Select Basic for authentication
- Preview the data and load it in Power BI
Regards,
Waka Wafubwa
On Thu, Mar 22, 2018 at 3:14 PM Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Channara,
you create the token on Powerbi. See link below with some useful hints.
https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-with-azure-ad
Regards,
Michael
On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Has anyone been able to do this with dhis2 2.30?
I am failing somewhere.
Anyone to assist.
On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Very helpful. Thank You!
Asif Ilyas | Business Systems Manager
International Rescue Committee
On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:
Hi Michael,
Do you have guide for option 2: connect through web API?
how can i find dhis1 api token key?
On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:
Hi Stanley,
you basically have two options for this.
- download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
- make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.
I hope this helps.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:
Anyone with experience linking Power BI and DHIS2 for further analysis .
Anyone
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Thank you all.I have been able to go round this and it is working for me.
Stanley
Looking for help: Does any one have experience pushing Event reports to PowerBi using just the PowerBi interface? We are testing the method shared on this thread by Waka for Pivot Tables.
Specifically, the URL for our event report /instance.org/api/reportTables/UID/data.csv doesn’t appear in the browser or in the PowerBi admin panel.
We’re wondering if there is a different call (not reportTables) for Event Tables? Or perhaps we need to modify our events into pivot tables, and Events won’t work using this method…
Any help or advice is greatly appreciated.
I have contacted the team at FHI360 as they noted expertise in this. We also know that BAO is building a PowerBi-DHIS2 connection (that we’ll test too, when it’s ready).
Thank you,
Sara Gaudon
LogicalOutcomes
I have a clarification question that I will post under Support - for Event Report, we don’t have the right API call. The bold format will work for Pivot tables (allow .csv download) but not Event Reports…
Dear team,
I followed all work flow; However, when I put URL and thereafter Power BI didn’t show “Access Web content form” for user author (Username and password). Any help (need to resolve it in urgent. Thanks1)?
Hi @skalyati,
Could you help to show step by step? when I put URL and thereafter Power BI didn’t show “Access Web content form” for user author (Username and password). thanks!
Hi @LCaynar,
It worked for me when i tried but ofcourse not as exactly as it was outlined.Let come back to you this afternoon with the instructions.
Cheers!
Hi Sara,
You can create a favorite on your event report and then use the favorite id on the url.
It works for me.
Regards