Forum Discussion
dynamic url for api calls using Web.Content
Hi Anonymous
If you want to refresh it in Power BI Service, the base URL must be static. Power BI will treat a base URL as a data source.
Jira has many kinds of APIs. Based on research, some of its APIs starts with "https://api.atlassian.com" but not sure if the resources you are querying has URLs of this structure. You may seek answers of this question at Atlassian Community.
In addition, if the endpoints don't have such URLs with the same base URL, you may consider connecting to those URLs separately in different dataflows or semantic models. Then combine them into a single dataflow or semantic model for further reporting. If the number of companies is not large, this can be an alternative. What's more, if each company's endpoint requires different authentications, you will also have to treat them separately. The endpoint for authentication or getting a token might be different too.
Hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
hello Anonymous, thats what im doing at the moment but im trying to keep the data structure less laoding and less tables and appends