Forum Discussion
Power BI Data Service v Desktop Refresh
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.
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!!
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.
