Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Getting this error when trying to show data by dates. I have a direct query getting data from Dynamics, each opportunity has a specific date. There is another static excel spreadsheet where I have aligned the opportunity date to a row on the excel to align it with fiscal year/quarter. Everytime I try to include data from the static excel sheet, I get this error. Can anyone help?
40197 means that your Azure SQL database source in CDS/Dataverse/Dynamics had a bit of a lay-down. If the error persists you may want to raise a ticket.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.