Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
57 | |
36 | |
34 |
User | Count |
---|---|
99 | |
56 | |
56 | |
46 | |
40 |