The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
so basically Active Directory as a data source for refresh isnt supported.
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.
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
It's the column name.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.