Forum Discussion

maden79's avatar
maden79
New Member
9 years ago

Dataset from dynamic worksheet

Help!   I'm trying to connect a dataset to a Dynamic Worksheet so that I can refresh data from CRM. To upload the dataset into PowerBI I'm prompted to convert my dynamic spreadseet into a table (Ct...
Need Help
Tutorial Requests
martinbell's avatar
martinbell
New Member
6 years ago

Did you get a solution to this.  I am having the same trouble

  • rigreen's avatar
    rigreen
    Microsoft Employee
    6 years ago

    +1 to this

    • Jimmy801's avatar
      Jimmy801
      Community Champion
      6 years ago

      Hello

      rigreen, maden79 , martinbell 

       

      there are multiple ways to access worlbooks/worksheets dynamically. But to answer your question I absolutly need your real life example (where is/are the file/s, structured all the same way? What content you exactly have to access (table, sheet, range?))

      Without this information it's impossible answer... it would only be guessing

       

      Have a nice time

       

      Jimmy

      • martinbell's avatar
        martinbell
        New Member
        6 years ago

        Hi Jimmy,

         

        Thanks for your reply.

         

        I am taking a dynamic worksheet from Dynamics 365, authenticating the data connection in Excel and then saving it to One Drive for Business.

         

        The idea is to build a report in Power Bi Report builder that uses this refreshable worksheet as the data source from Power Bi.

         

        All goes well until I try to upload the Workbook to Power Bi as a dataset as I am forced to turn the excel data into a table which then kills all of the data connections and refresh ability of the report dataset.