Forum Discussion
Publish raise a missing column error but client refresh works fine
Hi,
When I am using the PBI web, it refresh the data every 24h, and the result is:
"Exception Error" The cloumn 'Matar ID" of the table wasn't found. The exception was raised by the IDbCommand interface. Table: Prices
While using the PBI client, i tires 'Refresh' only and it is working properly without any changes
Can you please advise here?
Thanks
Hi HanKir76,
Thanks for reaching out to the Microsoft Fabric Forum Community.
This issue can happen for a few reasons. Here are some common causes and how to fix them:
Column Name Issue: Double-check the column name for typos or case differences for example, Matar ID vs Matar Id. Power BI Service can be case sensitive.
Schema Changes: If the column was recently renamed or removed from the data source, Power BI Service might not be aware. Try refreshing the schema in Power Query and review all applied steps.
Local vs. Service Behavior: Power BI Desktop might be using cached metadata or handling minor mismatches more flexibly. The Service enforces stricter checks during refresh.
Gateway or Credential Issues: If you're connecting to an on-premises data source, make sure the gateway is running properly and that credentials are correctly set in the Power BI Service.
If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.
Best regards,
Prasanna Kumar
2 Replies
Hi HanKir76,
Thanks for reaching out to the Microsoft Fabric Forum Community.
This issue can happen for a few reasons. Here are some common causes and how to fix them:
Column Name Issue: Double-check the column name for typos or case differences for example, Matar ID vs Matar Id. Power BI Service can be case sensitive.
Schema Changes: If the column was recently renamed or removed from the data source, Power BI Service might not be aware. Try refreshing the schema in Power Query and review all applied steps.
Local vs. Service Behavior: Power BI Desktop might be using cached metadata or handling minor mismatches more flexibly. The Service enforces stricter checks during refresh.
Gateway or Credential Issues: If you're connecting to an on-premises data source, make sure the gateway is running properly and that credentials are correctly set in the Power BI Service.
If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.
Best regards,
Prasanna KumarThank you, managed to resolve it based on your answer. It was credentials issue, the local refresh was on a differant user that the web refresh, fixed it and problem resolve
"
Gateway or Credential Issues: If you're connecting to an on-premises data source, make sure the gateway is running properly and that credentials are correctly set in the Power BI Service."
