Power Pivots not working since we moved from SQL server to Oracle

[ad8833]

Hi All ,

We recetnyl moved from SQL server to Oracle and now we are facing issues with refrehsing the Power Pivots.It was working fine earlier when we had SQL server.

Any suggestions!!!!

Thanks!

[Daryl-Lynch-Bzy]

Hi @ad8833 - I want to understand how Power Pivot in Excel was connecting to SQL Server and Oracle.  Was the connection made directly from Power Pivot or indirectly using Power Query (aka Get & Transform).  So, my first question is "do you understand what I am talking about"?