Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi ,
When viewing Direct Query Report , I get the following error:
Underlying ErrorPowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DM_GWPipeline_Gateway_ProviderDataAccessArgumentError
Underlying error messageUnable to find the requested .Net Framework Data Provider. It may not be installed.
Correlation ID6f7da22c-4b97-003e-5aa6-b9790b0eeae2
DM_ErrorDetailNameCode_UnderlyingHResult-2147024809
Activity ID31daae7b-48ff-406e-b8a8-cd6777000bf7
Request ID2765762b-5d57-3541-6c0c-efb0a8fc6ed2
TimeWed Feb 03 2021 15:56:48 GMT-0500 (Eastern Standard Time)
Service version13.0.15302.46
Client version2101.4.04609-train
Cluster URIhttps://wabi-canada-central-redirect.analysis.windows.net/
Please help . The .net fromework version is 4.8.03761
@Anonymous - We ended up opening support ticket with Microsoft . Here are steps recommended to resolve the issue in gateway machine:
1) Reinstall ODAC driver 64 bit.(not Xcopy)
2)During installation you have to select the following:
3)
@GilbertQ Reports with import mode are working. Only Direct query reports have iaaue
@GilbertQ Thanks for responding. The machine on which gateway is running is 64 bit. I see both Framework and Framework64 folders in the machine . The registry seems to be pointing to Framework folder. I think this is 32 bit version of the .net framework but not entirely sure.This is how full registry looks like
Should this be pointing to Framework64? IF so how can we fix this?
Thanks again,
Savita
Hi @savitaa Were you able to get this issue resolved?
I am facing exactly same issue.