Forum Discussion

NadiaLR1234's avatar
NadiaLR1234
Icon for Helper I rankHelper I
4 years ago
Solved

Replace a data table with another and keep visuals and in query measures

I use SQL View Query Datasets (Import option) and would like to know if there is a way to AFTER I have built a whole report with multiple visuals, in query measures / calculated columns to just replace the data table with another one (all headings are the same) basically just save as another report and replace with another sql view datatable and keep all the visuals/measures/calculated columns in tact ?

 

Also why is the size of the datasets such an issue ?? Is there a way to have unlimited import size on a dataset ?? Or how can I have huge datasets (without hassles 

 

 

Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    If you go into transform data, click the current table you can swap the M code in the advanced editor. Provided columns are the same visuals should maintain.

     

    Dataset size refers to the size after it is in vertipac which has amazing compression. The whole thing however is loaded into memory at that point so the bigger it is the more resource it uses. If you're using a star schema power bi can handle vast data sets. Have a read of Data reduction techniques for Import modeling - Power BI | Microsoft Docs

2 Replies

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    4 years ago

    If you go into transform data, click the current table you can swap the M code in the advanced editor. Provided columns are the same visuals should maintain.

     

    Dataset size refers to the size after it is in vertipac which has amazing compression. The whole thing however is loaded into memory at that point so the bigger it is the more resource it uses. If you're using a star schema power bi can handle vast data sets. Have a read of Data reduction techniques for Import modeling - Power BI | Microsoft Docs

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi NadiaLR1234 

    Have you solved this question with bcdobbs's help? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

    Also, I notice that you are new to forum, maybe there is something unfamiliar, let me take a screenshot to demonstrate,

    If you need more help, please let me know.

     

    Best Regards,

    Community Support Team _Tang

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