Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
I keep getting an OLE DB or ODBC error: Exception from HRESULT: ox80040E1D error message although the data does get refreshed in the query editor.
When I refresh the data in the query editor everything works fine, but outside the query editor I get the message,
I haven't seen any working answer from previous Forums.
Thanks.
Solved! Go to Solution.
Thank you for the response.
I figured it out.
The error occurred when appending datasets with different data formats. The data I was querying had one date format and the already queried data had another.
if Column type is changed in transform query..still this error persist?
Hi @eliele
Please show me the information so that i can reproduce your problem.
1. which kind datasource, excel, sql ...?
2. which connection, import,direct query?
3. could you share the code in Advanced editor so that i can know what steps you applied?
Best Regards
Maggie
Thank you for the response.
I figured it out.
The error occurred when appending datasets with different data formats. The data I was querying had one date format and the already queried data had another.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.