Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
This is my very first message on a forum like this so if my question hard to understand or incomplete im sorry in advance.
But here is the problem im dealing with.
So the company im an intern in wants me to connect Power BI to their buisness. I have figured out how to download data from their API using the Desktop app, the thing is that it is about 40 tables i need and all have the same url string in the beginning it is only the end part that changes.
They want me to try to download all data with just one call/query/click so i've read a lot of posts here about having a parameter in the URL, dynamic URL and so on.
But from one of the post it seemed that I needed to first download one file and then edit so the last part of the URL is a parameter instead. But I want to define a parameter first and then by just one call download all the data into the different tables.
As I'm typing this Q, I get that it might be hard to understand what I want or what the problem is, so let me see if I can give an example.
Let's say I access the API with www.mydatasource.com/data/newdata and this takes me to a page that contains string like
''sales''
''revenues''
''CostOfGodsSold'' etc and by adding one of those strings to the end of the URL it automatically downloads the data in a CSV file, i.e www.mydatasource.com/data/newdata/sales will download the sales data .
So I wanna pass ''sales'', ''revenues'' and ''CostOfGodsSold'' as parameters when I first start Power BI desktop and then for Power BI to save all the data into separate tables.
Thank you for your help in advance
Best regards
Elijah
Solved! Go to Solution.
this article should help
https://blog.crossjoin.co.uk/2016/05/15/creating-m-functions-from-parameterised-queries-in-power-bi/
this article should help
https://blog.crossjoin.co.uk/2016/05/15/creating-m-functions-from-parameterised-queries-in-power-bi/
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |