Forum Discussion
Power BI Data Service v Desktop Refresh
Same issue I'm afraid yes. I think the reason it doesn't like it is that StepA
StepA = SharePoint.Files("https://goodhartpartnersllp383.sharepoint.com/sites/GlobalOpportunitiesTrust", [ApiVersion = 15]),
Ultimately feeds the next calling of the data in "source":
source = Json.Document(Web.Contents("https://query2.finance.yahoo.com", [Headers=headers, RelativePath="/v1/finance/screener?crumb=thB88nfrdYz&lang=en-GB®ion=GB&formatted=true&corsDomain=uk.finance.yahoo.com",Content=body2])),
because body2 is fed by StepZ11, which is fed by StepZ10 etc going all the way backwards to StepA
I've been looking into "Partionining" which would seem to be the answer.. But I just can't get my head around how to actually achieve it in this instance.
Yep. Your only chance ist to stuff everything into a single query. Calling one query from another won't work
Consider using a dataflow for the upstream query.
But that's what I am doing in the attached. Everything happens all in that code, and there are no separate Power Queries getting used. My issue is (I think) that one data source produces a result, that ultimately determines part of a next step that calls another data source... I'm not sure how to get round that part essentially.
Could I fold them into separate "partitions" within one query to make it work?
Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn
I thought that reading the above would get me there but it really hasn't.
I would really really appreciate any further help that you can please offer
Hi, i just posted a related post regarding privacy level. just to make sure my understanding is correct- it is not possible to merge a cloud source (SharePoint) to a SQL source? i have a sharepoint query and a SQL query, then in the sharepoint query I perform the merge to the SQL query. it will not work in this way?
It's not an SQL query. The key steps are basically:
- StepA uses = SharePoint.Files() to pull a full list of documents, then subsequent steps select the latest file in a folder...
- StepG opens the content from the CSV file, and ultimately pulls out a list of stock tickers
- StepN uses Csv.Document(Table.SelectRows(SharePoint.Files())) - no longer using Web.Contents() to open a static CSV file which converts (via a merge in StepR) the tickers from one format to another
- then source = Json.Document(Web.Contents()) to ultimately invoke an API with the headers that feature the tickers collected and converted in the steps above...
So I think the dependencies following on from one another causing the issue in the service? It all works fine in Desktop, just not service. I have all privacy levels set to Organisational.Oops! Sorry misread you as the original chap!!