How to Connect Power BI with SAP ECC

[Anonymous]

Hello Every One,

I want to import data from SAP to Power BI. when i try doing this, error message shows as.

[anupamj]

Hello @Anonymous  If PowerBI needs to fetch data directly from SAP ECC (say reports, queries, tables, views CDS etc) then the USB4SAP connector for PowerBI will be useful: Ecoservity – Ecosystem. Services. Technology

Besides realtime in PowerBI, you may also provision SAP data to a datalake/ DB / NFS & consume from there.

This is certified by SAP & Microsoft:  USB4SAP - Connectors | Microsoft Learn.

hope this helps. 
AJ

[Anonymous]

any help on this?

[truptis]

@Anonymous there are 2 ways to install or register an assembly in GAC

1st Method

Just drag and drop/ CopyPaste an assembly to an assembly folder.

To find an assembly folder first you need to check your windows installation drive, In my case my windows is installed in "C-drive" so its "C" drive C:\WINDOWS\assembly.

2nd Method

Using Microsoft .NET Framework SDK v2.0/V.4.0

Make sure that you installed .NET Framework SDK v2.0/V.40 in your mechine. If not Please download from the below given url and install it.

http://www.microsoft.com/en-us/download/details.aspx?id=19988 or http://www.microsoft.com/en-us/download/details.aspx?id=8279

1. Click Start > All Programs > Administrative Tools > Microsoft .NET Framework 2.0/4.0 Configuration.

2. Click Manage the Assembly Cache.

3. Select Add an Assembly to the Assembly Cache.

4. Browse and select your DLL, which you want to install it in GAC

5. Click Open. This will deploy the selected assemblies into the Global Assembly Cache (GAC).

6. Restart the IIS.

Please hit the thumbs up & mark it as a solution if it helps you. Thanks.

[truptis]

Hi @Anonymous ,

Please refer the below document:

https://learn.microsoft.com/en-us/power-query/connectors/sap-bw/sap-bw-troubleshooting

[Anonymous]

any help please on this error..?