Forum Discussion

Tilly01Hill's avatar
Tilly01Hill
Regular Visitor
9 months ago
Solved

How to save data upload parameters. I'm uploading data from a website daily.

I'm uploading data from the same website on a daily basis. The only parameter that changes is the date. How can I save the upload parameters so that I don't have to fully re-create them every day?
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi Tilly01Hill ,

 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

 

Thank you.

Tilly01Hill's avatar
Tilly01Hill
Regular Visitor
9 months ago

Hi

 Thanks for your reply and follow up email.

Please see the attached images showing the parameters that I'm using to try to import data from a website.

 As you can see, I get the get the error message asking for the "anonymous" setting, which is how I've got the parameters set.

 I've also included a screen shot of the Power Query, Transform data screen.  How would I enter my data parameters into this screen? Would you be able to provide me with a sample screenshot please?

 Regards

 Steve Hill

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 months ago

    Hello again Tilly01Hill ,

     

    Thanks for sharing the screenshots they really help clarify what is happening. The repeated Anonymous credential prompt is occurring because Power BI treats every variation of the URL as a completely separate data source, which means the service will not retain the saved authentication if the address changes. You can safely ignore that credential window once the base URL is set, because the parameter should be handled inside your query rather than in that pop-up.

    The most reliable way to keep things stable is to leave the base address fixed and pass only the changing date as a parameter in your M code. Power Query is fine with dynamic elements as long as the host itself stays the same, and following this pattern will allow the Anonymous credential to persist so you are not asked to authenticate every day. You can simply update the parameter in the Manage Parameters window or have your query generate the date automatically. There is no need to re-enter anything in the Access Web Content dialog or recreate the connection referencing the parameter directly in Web.

    Contents is all that is required. This approach keeps your credentials intact, avoids URL changes that break the connection, and makes your daily refresh process run smoothly without any extra steps.


    For more detail, the Microsoft Learn articles on the Power Query Web connector and on Web.Contents provide helpful guidance:
    Web.Contents - PowerQuery M | Microsoft Learn
    Power Query Web connector - Power Query | Microsoft Learn

     

    Thank you.