Power BI Reporting
Really struggling with and i hope someone can help me.
I already run a number of reports using PowerBI by exporting from Insightly into excel, and then into PowerBI,
What i would really like to be able to do is create some realtime reports, nothing complex, just things along the lines of how we are doing against target etc.
I remember there used to be a connector to PowerBI service, but I would like to utilize the API and link in with PowerBI Desktop, but what ever i try (which at this point is probably everything other than the actual answer) i can't seem to get the setup right.
I've tried putting the username as my ApiKey (Base-64 Encoded), I've tried adding it in through Headers,
Am i just barking up the wrong tree here, and this is not possible?
Cheers for any help