SSAS POWER BI SERVICE- Export Limitation RRS feed

  • Question

  • Hi Experts , 

    This Question is related to Power BI (POWER BI SERVICE-PREMIUM) connect "Live Connection" with SSAS(MultiDimension).
    We are facing issue Exporting more data in .xlxs file.
    if we do not Import data in Power BI( Since we use Live Connection),Then Limit of data that can be exported is 16MB ( Mentioned in below Link)

    This comes out as major concern when Client try to Export data for more than one month or Quarter or Semester.
    Can we Increase the Export Size ?
    • Edited by MS308 Thursday, January 23, 2020 6:08 AM edit
    Thursday, January 23, 2020 6:07 AM

All replies

  • Hi MS308,

    Since the question is more related to Power BI, you'd better submit your doubts to Power BI forum for professional support. I don't clearly get the latest features and product release of Power BI.

    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Friday, January 24, 2020 7:26 AM
  • You cannot change those limits. Although the 16Mb limit relates to Direct Query models, not Live Connection reports. However there is still a 150,000 row limit. Power BI is really focused more on building interactive dashboards rather than doing data exports. If you need a higher volume of data maybe look at using a paginated report instead. - please mark correct answers

    Monday, January 27, 2020 9:47 PM