Forum Discussion
Data Agent Failing on Column/Table Names with Spaces
Hi willfleming,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The issue arises because the Data Agent auto converts column and table names with spaces (e.g., 'Created Date') into formats like 'Created_Date', causing failures when accessing Power BI datasets. Instead of manually renaming each field, easier workarounds include wrapping column names with spaces in square brackets in queries, creating SQL views or Power BI Dataflows with Data-Agent-friendly column names, configuring the Data Agent (if possible) to preserve original names, or using internal field names like 'Created_Date' while setting display names as 'Created Date' in Power BI. These approaches help maintain readability without breaking compatibility.
If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.
Thank you & regards,
Prasanna Kumar
Hi willfleming,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The issue arises because the Data Agent auto converts column and table names with spaces (e.g., 'Created Date') into formats like 'Created_Date', causing failures when accessing Power BI datasets. Instead of manually renaming each field, easier workarounds include wrapping column names with spaces in square brackets in queries, creating SQL views or Power BI Dataflows with Data-Agent-friendly column names, configuring the Data Agent (if possible) to preserve original names, or using internal field names like 'Created_Date' while setting display names as 'Created Date' in Power BI. These approaches help maintain readability without breaking compatibility.
If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.
Thank you & regards,
Prasanna Kumar