Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I used this following Web.Content code to get data. It works fine on desktop, but it will not allow me to update data in Service – I get the error message that dynamic data sources can’t be refreshed.
let
Balance = (EndDate as text) =>
Let
Source = Json.Document(Web.Contents("https://tripletex.no/v2/balanceSheet?dateFrom=2019-01-31&dateTo="&EndDate&"&includeSubProjects=false... XXXXXXXXXXXXXXXXXXXXXXXXXXXXX"]])),
values = Source[values],
I have tried to tweek it using RelativePath to the following:
let
Balance = (EndDate as text) =>
Let
Source = Json.Document(Web.Contents(https://tripletex.no/,[RelativePath=”v2/balanceSheet?dateFrom=2019-01-31&dateTo="&EndDate&"&includeSubProjects=false&includeActiveAccountsWithoutMovements=false&from=0&count=1000",Headers=[authorization="Basic XXXXXXXXXXXXXXXXXXXXXXXXXXXXX"]])),
values = Source[values],
Again, works fine in desktop, but now I get a new error message in Service when I update the data saying:
"Processig error [Unable to combine data] Section1/XXX/Expanded ParameterXXX reference other queries or steps, so it may not directly access a data source. Please rebuild this data combination."
Can someone please help me so that I am able to update the dataset in services?
Much appreciated 😊
Solved! Go to Solution.
Thank you 🙂 I managed to solve it. The issue was that my dynamic source was a dynamic date table referring to another query as start date. It worked in PBI service when I changed that and used the second version with RelativePath 🙂
Thank you 🙂 I managed to solve it. The issue was that my dynamic source was a dynamic date table referring to another query as start date. It worked in PBI service when I changed that and used the second version with RelativePath 🙂
Hi, @Anonymous
Glad to hear that you have solved your problem by yourself, would you like to mark your own reply as a solution so that others can learn from it too?
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you seem to have two issues. For dynamic url content use the Query= parameterization of a static URL. For the other issue please read this article: Feedback wanted: Behind the Scenes of the Data Privacy Firewall (microsoft.com)