Trying to connect Power BI to Dynamics 365 Online via the CDS connector. When I navigate to the entity that I want (Opportunities) the data is correctly loaded into Power BI. However, when I go to Edit Queries -> Power Query Editor I am getting the following error:
DataSource.Error: Cds: Request failed: Unable to connect to the remote server
Thanks for that. However, I can get the connection to work on smaller tables & edit the data. When I try to edit my main (larger) tables the errors are occuring and I cannot edit/transform the data in the Power Query editor.