Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am getting the error below when I try to pull data from a dtabase file.
I am able to load data from other files in the same database, but this one will not go. I see a message indicating that it is loading the data into the data model, but hten it fails. If I go into Power Query, the table is there and the data is in it. However when I exit Power Query to go back into the Power BI desktop I get the same error as above. I am preplexed.
Cheers,
Peter
Solved! Go to Solution.
@pkoel-asb , Please check is it a connection timeout issue? Means it taking some time and then erroring out ?
Hi @pkoel-asb ,
This picture is too small for me to see exactly what's on it.
Can you provide a clearer image to report the error?
Alternatively, you can see a similar solution in the following article, using the MS Store version of Power BI Desktop.
@pkoel-asb , Please check is it a connection timeout issue? Means it taking some time and then erroring out ?
It was a connection issue. I rpelaced the VPN software with a company router and all is now working well.
Hello,
Thank you for the reply. I am able to load the data in Power Query. It is only when I close and apply that I get the able ODBC error. I started delteing fields from the table (in Power BI Desktop) and found that if I delete about 1/2 the columns; the table will load without getting the ODBC error. I do not understand why this is happening. I did go into file-options and settings-options and clear the cache files (just guessing, but did nothing)
Peter
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |