Issues while trying to build a graph connector to Azure SQL in M365 copilot
Dear All,
I tried to create a Graph Connector to Azure SQL. I wanted to ingest data from Azure SQL and ask questions about it within Copilot for Microsoft 365.
The graph connector was created in this Microsoft 365 Admin Centre within the ‘Data sources’ section in ‘Search and Intelligence’ menu: https://admin.microsoft.com/#/homepage
The Microsoft documentation (https://learn.microsoft.com/en-us/graph/connecting-external-content-experiences#copilot-for-microsoft-365) screenshot below states that in order for the information to surface in Copilot for Microsoft 365, the fields “title,” “url,” and “iconUrl” need to be filled out during the configuration process. However, during the configuration process, I noticed that the ‘iconUrl’ field is greyed out. Hence, I am not able surface data from Azure SQL in Copilot for Microsoft 365.
On the other hand, Microsoft Search and Sharepoint both displayed the Azure SQL data as I proceeded to configure the connector anyway.
Is there any workaround for this? Are there any alternative approaches that I can take to surface the data in Copilot chat? Would appreciate any help regarding the same.
Dear All,I tried to create a Graph Connector to Azure SQL. I wanted to ingest data from Azure SQL and ask questions about it within Copilot for Microsoft 365. The graph connector was created in this Microsoft 365 Admin Centre within the ‘Data sources’ section in ‘Search and Intelligence’ menu: https://admin.microsoft.com/#/homepageThe Microsoft documentation (https://learn.microsoft.com/en-us/graph/connecting-external-content-experiences#copilot-for-microsoft-365) screenshot below states that in order for the information to surface in Copilot for Microsoft 365, the fields “title,” “url,” and “iconUrl” need to be filled out during the configuration process. However, during the configuration process, I noticed that the ‘iconUrl’ field is greyed out. Hence, I am not able surface data from Azure SQL in Copilot for Microsoft 365. On the other hand, Microsoft Search and Sharepoint both displayed the Azure SQL data as I proceeded to configure the connector anyway.Is there any workaround for this? Are there any alternative approaches that I can take to surface the data in Copilot chat? Would appreciate any help regarding the same. Read More
