Forum Discussion

utsavlexmark's avatar
utsavlexmark
Icon for Helper III rankHelper III
8 years ago

Continuous Data in Multiple Tabs (in Excel) as Source

Hello, I have created a dashboard where the data source is an excel. Now the data is being incresing and I have doubt that within next few days I have to move to a different tab - coz maximum rows l...
Michal_cwiok's avatar
Michal_cwiok
Icon for Resolver II rankResolver II
8 years ago

It is feasible, but will require some changes to the model. Make sure that your data is in the same format. To download the data from multiple sheets just click Expand after connecting to the Excel file. Just like below:

 

 

  • utsavlexmark's avatar
    utsavlexmark
    Icon for Helper III rankHelper III
    8 years ago

     

    First image to show the field names in both the sheet and 2nd image is to show what error data I am receiving.

    Data format are same in both the table, still I am getting the error.

    Please let me know if you want any more detail info.

     

    • Michal_cwiok's avatar
      Michal_cwiok
      Icon for Resolver II rankResolver II
      8 years ago

      Which query gives you this error? Have you tried using "Append" function?

       

      Would it be possible to get anonymized data from you? This would speed up development.

       

      Thanks

      • utsavlexmark's avatar
        utsavlexmark
        Icon for Helper III rankHelper III
        8 years ago

        This issue has been solved Michal, sorry for delay in answer.