Forum Discussion
Python requests working in Power Query not when loaded in Data Model
My Python script is not successfully loading into the Data Model. The script works; it runs in an IDE (I use Pycharm), and also runs and returns data in the Power Query Editor. I am using it to get d...
Update: passing a table in such as
Query1 = let
Source = Table.FromRecords({
[Name="url", Value="https://jsonplaceholder.typicode.com/todos/"]
})
in
Source
works in both the Editor and the Model - maybe it is an issue with the order of evaluation of queries with #sections? Still wish to use parameters as this exposes the variables in the service, so open to suggestions.