topic Document DB refresh connection in Report Server

Document DB refresh connection

Anonymous — Mon, 14 May 2018 18:12:25 GMT

Hi there,

I'm using the Azure Document DB connector to import data into a report that I'm building in PBI Desktop and publishing to PBIRS. As far as I can tell, the most direct way is to refresh my data is to open the report in PBI Desktop, refresh the connection there, and resave it to the report server. Can anyone confirm this, or otherwise suggest an alternate solution?

I read a rather complicated-sounding solution involving using Apache Spark to implement DirectQuery and I would rather not do that. I don't need the data to sync immediately; I just want to be able to schedule refreshes. The Refresh button in the online report server doesn't seem to update the data.

Thanks!

Liane

Re: Document DB refresh connection

Jon-Heide — Tue, 15 May 2018 00:42:53 GMT

If the data source supports basic auth, with user/pass info on the connection string, you can see if refresh will work. I believe DocDB uses AAD authentication which the server does not currently support, so a-sync refreshes will fail to authenticate. When you view it in PowerBI desktop, you are authenticated to the DB as yourself.

There is a 3rd party tool http://poweronbi.com/power-update/ power update which essentially automates the download, refresh, update workflow for you.

Re: Document DB refresh connection

Anonymous — Tue, 22 May 2018 14:36:02 GMT

Thanks Jon! Have you happened to use Power Update with PBIRS? It seems like it works great, except when it comes to publishing over an existing report. I've got a message out to their support but thought you might have come across this as well.

Best,

Liane