Forum Discussion

webbj's avatar
webbj
Helper I
3 years ago

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 cred...
Need Help
webbj's avatar
webbj
Helper I
2 years ago

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. 

 

 

  • Martin_D's avatar
    Martin_D
    Solution Sage
    2 years ago

    You can ignore the not folding symbol. That's not the problem.

    You need to explicitly refresh the dataflow at least once to see data in Power BI Desktop. The data in the editor is only preview. As long as you see data in the last step of the query ("Removed columns"), save & close the editor and then refresh the dataflow, and when the refresh is done, you should also get the same data into Power BI Desktop.

    • webbj's avatar
      webbj
      Helper I
      2 years ago

      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 refresh

      • Martin_D's avatar
        Martin_D
        Solution Sage
        2 years ago

        What I meant is that for each query that you create in a dataflow, when entering the connection setting you choose "new connection". After you have created the first query, the editor will by default suggest to use the existing connection for your second query, but other than in Power BI Desktop, now you can choose to create a new connection with different login credentials. That's what you need for connecting to these URLs with different logins.

        If you have access to the connections administration in your Power BI tenant then you can also create the separate connections with the different identities there upfront. The advantage is that you can give nice names to the connections in the connections adminsitration and set the scope of the connection explicitly to an URL including the query parameters.