cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
piyushmohnot Regular Visitor
Regular Visitor

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
piyushmohnot Regular Visitor
Regular Visitor

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

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.

Re: Scheduled refresh

piyushmohnot Regular Visitor
Regular Visitor

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

Re: Scheduled refresh

It's the column name.

Highlighted
piyushmohnot Regular Visitor
Regular Visitor

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 403 members 3,536 guests
Please welcome our newest community members: