If you have demo Project “Madeira”, you can also try to use Project “Madeira” automated Power BI. You need to use the same credentials and log to powerbi.com
Then, you need to run Services and choose Project “Madeira” package:
Choose “Connect” and put your OData Feed URL. You can find this URL in your Project “Madeira”. You need to find Web Services page using search and copy OData URL until your company name, as the following model: https://[navserver]/[instance]/OData/Company(‘Sample%20Company’).
Wait some time and type your credentials, using the basic authentication method. You need to use your O365 username, but as your password, you need to use your “Web Service Access Key”. To create your “Web Service Access Key”, go to the your User card in Project “Madeira” and use “Change Web Service Key” command to generate your “Web Service Access Key”.
After that, you need to continue with logging to your PowerBI. You don’t need to take care about certificates and similar; everything is already prepared. When you finish, you will get page similar as my. Then, you can check and try to make it funny…
Pretty easy. Enjoy.