Hello,
I know that this is not the first topic on this issue. I have read every one. And tried all the suggested options too.
But at least now I have enough knowledge to say that the problem is the following.
I have 2 connections:
1) API via token (anonymous, none). In this source, I have a service with a huge dataset.
2) Sharepoint.Files (OAuth2, organizational). From here I take the xlsx file, in which colleagues enter the names of organizations that are interesting to them this year (the file is sometimes updated).
Loading tables with millions of rows via the API is probably possible, but inconvenient. And the only data to filter the API request is the list of organizations from Sharepoint. And as soon as I start using data from this table in any way (merge, vlookup, list/parameter, query in query, table staging) to filter the request API I get this error. No combinations, privacy levels, etc. solve the problem.
Error in data source: [Unable to combine data] Section1/SourceFields/GetPage references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDbCommand interface. Table: SourceFields.
URI cluster: WABI-NORTH-EUROPE-F-PRIMARY-redirect.analysis.windows.net
Action ID: abf0fd63-093f-4910-a45f-076f1242f366
Query ID: 6eb61ed1-3ed5-c71f-4c65-3594b6c85e7d
I have a feeling that there is some very simple way, but I'm too dumb to notice it.
Thank you in advance. Konstantin.
