Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cannot set a scheduled refresh because my excel file is a 'dynamic data source'

Hi,

 

I want to schedule a regular refresh for my dashboard but my excel file (saved on a company sharepoint) is considered a 'dynamic data source'. 


I don't know why it is (it doesn't have any external data connections) but I am looking for a workaround. 

For more details:
Cluster URI: WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID: 00000000-0000-0000-0000-000000000000
Request ID: a81225b1-2a7a-4868-aae9-735295f1790e
Time: 2023-04-03 15:59:35Z

 

Looking forward to your suggestions 🙂

Report Server

3 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous ,

     

    I am not sure what you mean by a "dynamic Excel sheet"?  If the columns are not changing and only the data is changing then that would be a normal situation.  To connect to that sheet from the Service you will need to set up a gateway to get to the Excel sheet within SharePoint.  Then, your report can use that as the connection and it will refresh.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Yes, I realised I had imported my excel sheet instead of setting up a data connection. Now i'm re-building the report with this connection. 

      Or is there a faster way through a data gateway? 

      • collinq's avatar
        collinq
        Icon for Super User rankSuper User
        3 years ago

        Hey Anonymous ,

         

        I don't know about "faster" but if yo uwant to refresh it automatically you will have to use your gateway in the Service.  And, the data source that uses the gateway will have to have a connection to that Excel file.