User Profile
webbj
Helper I
Joined 4 years ago
User Widgets
Contributions
Re: Multiple Web Query
Hi Martin, so i've been trying to get this to work but I'm not sure what I am doing wrong. If you have the time could you write a dummies guide for me? Yesterday I was creating a workflow per query. But after reading your message I tried to add more queries/tables to a single workflow selecting create new connection. The queries are as following, each requiring a different username/password to access 1 = https://api.testdomain.com/api/reportextracts/?reportId=922&startDate=2023.01.01&endDate=2023.08.01 2 = https://api.testdomain.com/api/reportextracts/?reportId=966&startDate=2023.01.01&endDate=2023.08.01 But when a new table is added the old table stops working. and when I look at Manage connections I can only see one connectionRe: Multiple Web Query
Martin_D thanks, that worked. As I add further workflows I can no longer refresh the older ones without changing the password is this what you meant by "The main disadvantage is the refresh orchestration" i.e. setup dataflow refresh add to powerbi desktop then to refresh to get more data going forward set correct password refresh repeat per workflow that needs data refreshRe: Multiple Web Query
Martin_D Thankyou for responding to my query! Apologies for not responding sooner I have been away on holiday with no signal. I've put in a request for option 1 but not sure that they will provide such an account. So whilst I wait I am trying to get option 2 to work. (didn't know about dataflows) I've created a dataflow for one of the queries. the data appears in the online power query editor. however when i connect to it in powerbi desktop no data appears I believe that this is caused by the 'Not folding' symbol next to expanded results but I'm not sure what I've done wrong. Any help would be much appreciated, if you need more information please say so.Multiple Web Query
hello all, I was wondering if anyone can tell me how I can use multiple web credentials for seperate queries/tables. I need to call multiple of these, the only difference is the reportid and the credentials used. https://api.testdomain.com/api/reportextracts/?reportId=$reportId&startDate=$startDate&endDate=$endD... So once the first one is complete, password entered saved, data loaded successfully I then attempt to load the second. Upon the second attempt it'll error a generic 400 code. The resolution is to change the credentials saved which then breaks the previous query as the password is no longer correct. I was asked to post this here as I had posted in the wrong section! (sorry!) is there a way to add multiple credentials / differentiate between web links. I hope that this makes sense, if anyone needs more information please let me know.Multiple Web Query
hello all, I was wondering if anyone can tell me how I can use multiple web credentials for seperate queries/tables. I need to call multiple of these, the only difference is the reportid and the credentials used. https://api.testdomain.com/api/reportextracts/?reportId=$reportId&startDate=$startDate&endDate=$endDate So once the first one is complete, password entered saved, data loaded successfully I then attempt to load the second. Upon the second attempt it'll error a generic 400 code. The resolution is to change the credentials saved which then breaks the previous query as the password is no longer correct. is there a way to add multiple credentials / differentiate between web links so I can use seperate credentials. I hope that this makes sense, if anyone needs more information please let me know.Combining Multiple Rows /Transposing each category ID to its own column
Hello all, I believe what I am attempting to do is combine multiple rows from my table. The core of what I want to do is combine all duplicated ID rows into a single row and have a seperate column per category id. The Issue: As each category is on a seperate row it is creating multiple seperate entries for each ID which means I cannot filter on multiple categories. When trying the graphs go blank. What I need to be able to do: create a graph/report that can be filtered against multiple criteria i.e. a chart showing sentiment over time filterable by location. RAW data view Here is how the data initially appears via the API - I have removed some columns so I can post here. categories.path is the main category grouping and then categories.name is the subcategory. Journey so far I have seperated the table into Results and Categories, and created a relationship between them using the results.category.id in Results and available.categories.id in Categories. I created a quick excel spreadsheet to import to see if each category was a column rather than a row I could apply multiple filters, this seemed to work. What I am trying to do Create seperate tables for each category Merge those tables into the results table to create the seperate columns using the existing results.category.id and the id in the new table. Remove the existing results.category.id column Merge each row with the same ID so I end up with something similar to the excel spreadsheet demo. ID, Date, Comments, channel.id, sentiment.id, etc Is there a better way to go about this scenario? How can I combine / flatten each id into a single row whilst keeping the value's present in the newly added columns? I hope this makes sense, if any more information is required please let me know.
