Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic datasource sharepoint not refreshing

Hi, 

 

I need to pull excel files that are in different folders on SharePoint.
I have made a function to dynamically pull data depending on the name/folder they are in.
This works fine in desktop:

 



However dynamic datasource does not refresh in Service. I tried to use the Web.Contents method but it does not seem to work, the code:

Need some help here 🙂




 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please check like the methods below to see if it can be a supported datasource.

    In most cases, Power BI datasets that use dynamic data sources cannot be refreshed in the Power BI service. There are a few exceptions in which dynamic data sources can be refreshed in the Power BI service.

    To determine whether your dynamic data source can be refreshed, open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File. In the window that appears, look for the following warning message, as shown in the following image:

     

    If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that cannot be refreshed in the Power BI service is present.

     

     when using the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

    For more details，you can refer to：

    Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code 

     

     

    Hope it helps,

     


    Community Support Team _ Caitlyn

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , when refreshed, does it give any error. Can you share the same?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This fuction and manual refresh in desktop works. In Service it fails to refresh and I get the message --> the following data source currently don`t support refresh (dynamic data source).

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Please check like the methods below to see if it can be a supported datasource.

    In most cases, Power BI datasets that use dynamic data sources cannot be refreshed in the Power BI service. There are a few exceptions in which dynamic data sources can be refreshed in the Power BI service.

    To determine whether your dynamic data source can be refreshed, open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File. In the window that appears, look for the following warning message, as shown in the following image:

     

    If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that cannot be refreshed in the Power BI service is present.

     

     when using the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

    For more details，you can refer to：

    Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code 

     

     

    Hope it helps,

     


    Community Support Team _ Caitlyn

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