Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Document DB refresh connection

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 ...
DocumentDB
Jon-Heide's avatar
Jon-Heide
Microsoft Employee
8 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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