Forum Discussion

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi KervBruce ,

    If you want to enable scheduled refresh for dynamic queries in Power BI, you can use the Web.Contents() function along with the RelativePath parameter. 

     

    You can follow the steps below: 

    Use the Web.Contents() function in your Power Query M code.
    Incorporate the RelativePath parameter to specify the dynamic part of your query.
    Ensure that your query parameters are set up correctly to work with the RelativePath parameter.

     

    Also you can read this topic for a further study: Solved: Scheduled Refresh using Dynamic Data Source - Microsoft Fabric Community

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.