cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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 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

2 REPLIES 2
Microsoft
Microsoft

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. 

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors