Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the PBI desktop program in Windows 10 version 2.76.5678.782 64-bit (December, 2019) and have experienced an error this week while using our most utilized pbix dataset and when trying to create a new a new pbix file both with a connection to an Access database.
The Error is:
DataFormat.Error: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
I have tried the following:
- copying the database directly to my computer instead of our network.
- creating a new database with 1 table from the old database
I keep getting the same error, I can connect to the data momentarily (1 or 2 times) but, any time I start to transform the data I get this error and can't continue.
Does anyone have any next step advice/suggestions?
Solved! Go to Solution.
Hello @Brew42
it seems that in some part of your table you have an transformation error.
Try to apply a Table.SelectRowsWithErros to see if there are some error after applying a Type conversion
Hope that helps
Jimmy
Hello @Brew42
it seems that in some part of your table you have an transformation error.
Try to apply a Table.SelectRowsWithErros to see if there are some error after applying a Type conversion
Hope that helps
Jimmy
"Try to apply a Table.SelectRowsWithErros to see if there are some error after applying a Type conversion"
Where do you apply the so called "Table.SelectRowsWithErrors". Could you please be more specific?
In the query editor, the link below might useful to you.
https://docs.microsoft.com/en-us/powerquery-m/table-selectrowswitherrors
This helped. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.