Forum Discussion
Helper IIIPower BI Data Service v Desktop Refresh
Super UserYep. 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.
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?
jmillsjmillsIt'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.- jmillsjmills
Oops! Sorry misread you as the original chap!!
- lbendlin
Read the article again. It is rather hard to digest, but the gist is that you must put everything into the same partition.
Consider the dataflow.