Export Tables from Power BI Datasets to Azure Blob

[abhiram342]

Hi All,

Can anyone please tell best practices for exporting tables from power datasets to Azure Blob?

Thanks,

Abhiram

[collinq]

Hi @abhiram342 ,

If you have the permissions to export data and the visual allows for the data to be exported, then you can export from the visual to a csv or to excel.  But, there are row limits of how much data is exported, 150,000 I believe.  Exporting/Copying directly from the query is even more limiting.  The other option would be to use R or Python to do the export  - I do not low if there are row limitations using either of those methods.

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!