Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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

 

Check here

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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

 

Check here

Anonymous
Not applicable
Anonymous
Not applicable

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.

Anonymous
Not applicable

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

Anonymous
Not applicable

It's the column name.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Top Kudoed Authors