Forum Discussion

Sidhant's avatar
Sidhant
Icon for Advocate V rankAdvocate V
1 year ago

Managing and Exporting High-Volume Datasets (~1M Records) in Power BI

Hello everyone, I'm currently working on a use case where I need to manage and export high-volume datasets (~1 million records) using Power BI, and I'm exploring multiple approaches. I’d appreciate ...
Need Help
Gabry's avatar
Gabry
Icon for Super User rankSuper User
1 year ago

I've never tried this myself, but I was thinking, if you're using Fabric, one possible solution could be the following:

You can set up a report with a column filter. Then, using a user data function, you can trigger a notebook that receives the selected columns as input. The notebook can export the filtered data and save it to a folder within the lakehouse. Users can then access the data directly from that folder.

Could this be a viable solution?

  • Sidhant's avatar
    Sidhant
    Icon for Advocate V rankAdvocate V
    1 year ago

    Hi Gabry ,
    Thanks for the response, I'll check this approach and see if resolves my issue. I will keep you posted on this.

    Regards,
    Sidhant.