Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Download DataSet

Hi,

 

I need help on requirement where we need to downoad the dataset from the power bi report that has live connection.

 

Thanks in advance for your help.

 

Need Help
Tips and Tricks

2 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    A live connection means that Power BI is directly connecting to the originating source (SQL for example).  Therefore, you aren't downloading anything from Power BI as much as you can get the dataset from the original source - SQL for example.  The data stays in your original database.

     

    If you are asking about exporting the data FROM Power BI I guess that you could create a table visual and export from there - but that has a 150,000 row limit to Excel.

     

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , Anonymous 

    There are many modeling limitations in live connect mode, I am afraid it is difficult to directly export the data model of the underlying data.

    Best Regards,
    Community Support Team _ Eason