Forum Discussion
Data from two url's in power query
I have created in Visual studio a Power Query connector.
[DataSource.Kind="TimSaas", Publish="TimSaas.Publish"]
shared TimSaas.Contents = (optional ViewId as text) =>
let
apiUrl = "https://xxxxxxxxxApi/",
options = [RelativePath = "/api/PowerTestBiAccess],
apiData = Json.Document(Web.Contents(apiUrl , options),65001)
in
apiData ;
This works and give me the data in PowerBi in Query1
From an other url I want to have the data in PowerBi in Query2.
How can I do that?
I have modified the API and made sure that all necessary data is included in one call.
I then convert the Json output in Power Query to different tables (Queries). This works.
2 Replies
daxCommunity Support
Hi HuibSteen ,
I am not clear about your problem, if you want to create another power query, you could try to right-click solution->add new item and add corresponding items in resource file to see whether it works or not
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have modified the API and made sure that all necessary data is included in one call.
I then convert the Json output in Power Query to different tables (Queries). This works.