Importing data into excel or PowerBi

[eddablin]

Succeeded with both. See this to start with

Getting data into PowerBi

@eddablin Got it all up and working, thank you. Have you managed to get it published to powerBI web and can you schedule refreshes? If so how did you get past the authentication on PowerBI Web?