topic Re: Scheduled refresh in Report Server

Scheduled refresh

Anonymous — Wed, 11 Apr 2018 08:48:35 GMT

Hello everyone,

I have recently published a report on PowerBI Report Server. It has multiple data sources (SQL server and Active Directory). But scheduled refresh shows an error as shown below in the image. Refresh works fine in Desktop client though.

What could be the exact problem I'm facing? Any help?

Thanks and Regards,

Piyush

Re: Scheduled refresh

Anonymous — Wed, 11 Apr 2018 11:47:02 GMT

Hi @Anonymous,

This happens in SQL server when two objects have similiar name,

Same fileds name might be there on two differnt table, try to add some prefix in that and then agagin deploy the files and run the scheduler. It should be good.

Re: Scheduled refresh

Anonymous — Wed, 11 Apr 2018 11:45:44 GMT

This is the same issue :

https://community.powerbi.com/t5/Report-Server/Schedule-issue-An-item-with-the-same-key-has-already-been-added/td-p/344209

Re: Scheduled refresh

Anonymous — Wed, 11 Apr 2018 12:56:35 GMT

Hi @Anonymous,

Thanks for replying but by field name, you meant the column names or the data ? I didn't understood it properly. I checked and there was no columns with same name after merging two tables.

Thanks and Regards,

Piyush

Re: Scheduled refresh

Anonymous — Wed, 11 Apr 2018 16:49:29 GMT

It's the column name.

Re: Scheduled refresh

Anonymous — Tue, 17 Apr 2018 07:13:42 GMT

so basically Active Directory as a data source for refresh isnt supported.

Check here