Hi
We currently use the R-Script solution to integrate with PowerBI for reporting. However, this solution does cause issues as the script seems to need changing every 12 months (and when you have 50+ reports to update, it's not good)
We're now looking at using the data export tool to extract a few key data sets to a SQL instance on Azure. We will then use that as the data source for PowerBI reports.
Has anyone else done this yet?
If so, it would be great to hear what you learnt from the process
Thanks
Darren