Forum Discussion

JyotiBora's avatar
JyotiBora
New Member
3 months ago
Solved

Data Upload Issue

   Hi Team, I am trying to fetch data in Power BI desktop using data flows in import mode. It was working fine until we tried adding 1 more column. The dataflows are fine, giving the ...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    3 months ago

    JyotiBora 

    1. Create a M Query parameter.

    2. Reduce the amount of data that you load in to power bi desktop using a conditional logic based on the parameter value.

    3. Complete your development activities. 

    4. Publish your report to power bi service.

    5. Change the parameter value in power bi service. And supply necessary data source connection credentails or connection mapping.

    6. Trigger an on demand data refresh.

    7. Once the refresh is completed. If you want you can download the report again and perform any other activities in your file. 

     

     

     

    Checkout this page for sample steps: Chris Webb's BI Blog: Limit The Amount Of Data You Work With In Power BI Desktop Using Parameters And Deployment Pipelines 

     

     

     

     

     

    Connect on LinkedIn

     

     

     



    Read my blogs here: TechieTips




    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!
krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
3 months ago

Hi JyotiBora 

Error refering to Power BI Desktop RAM usage during import refresh process and not only dataflow itself. As issue started after adding new column to 16 million row table, column will increase the model size due to cardinality.

Try removing unnecessary columns, reduce data volume before loading, ensure correct datatypes,  and confirm usage of 64-bit Power BI Desktop. If the dataset continues to grow then consider DirectQuery