One Drive auto refresh on PBI RS

[Anonymous]

Hey, guys! What's up?

I have an dashboard that uses a few data from Google Analytics, and I found out in the moment that I published on my on premise PBI Report Server, that was not a connector avaiable for auto refresh.

So, OK.

I did a little trick using Google Sheets, Microsoft Flow and One Drive for Business to create and update a *.csv file with the information I needed.

Then, I went to my dashboard and create a new source with the direct link to One Drive, put my Organizational Credentials everything was beautiful until I deployed again to PBI RS.

The type "Organizational Account" isn't avaiable on the schedule configuration.

Is it really impossible put it an One Drive file on auto refresh?

[mpsrshl]

https://community.powerbi.com/t5/Issues/Datasource-for-CRM-365-in-Power-BI-Report-Server-Unable-to/i...

They simply haven't enabled us to use organizational login which is a shame.