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

Scheduled refresh

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.

 

SCCM_Refresh_error.JPGWhat could be the exact problem I'm facing? Any help?

 

Thanks and Regards,

Piyush

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Re: Scheduled refresh

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

 

Check here

View solution in original post

5 REPLIES 5
Highlighted
Resolver II
Resolver II

Re: Scheduled refresh

Hi @piyushmohnot,

 

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.

Highlighted
Resolver II
Resolver II

Re: Scheduled refresh

Highlighted
Helper II
Helper II

Re: Scheduled refresh

Hi @jayant_patel,

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

Highlighted
Resolver II
Resolver II

Re: Scheduled refresh

It's the column name.

Highlighted
Helper II
Helper II

Re: Scheduled refresh

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

 

Check here

View solution in original post

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors