DM_GWPipeline_Gateway_ProviderDataAccessArgumentError

[savitaa]

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

[savitaa]

@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)

[Anonymous]

Thanks @savitaa , Will try this!!

[savitaa]

   @GilbertQ  Reports with import mode are working. Only Direct query reports have iaaue

[savitaa]

@GilbertQ  On prem gateway is o. Latest version

[GilbertQ]

Hi @savitaa 

Are any other data sources working?

Also have you got the latest version installed?

[savitaa]

@GilbertQ  It is in standard mode

[GilbertQ]

Hi @savitaa 

have you installed the Gateway in Standard or Personal mode?

[savitaa]

@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

[Anonymous]

Hi @savitaa Were you able to get this issue resolved?

I am facing exactly same issue.

[GilbertQ]

Hi @savitaa can you confirm it is the 64bit version of the Dot Net Framework?