Forum Discussion
downloading power bi visual automatically
i have a table visual in power bi web which has 88 columns and over 70000 rows i want to creata a automated process to autodownload the data in sharpoint , i have tried using power automate but data is sampled only 1000 rows get downloaded
Can anyone help to download en
7 Replies
- Idrissshatila
Super User
Hello babban,
check this video for exporting up to 100K rows
https://youtu.be/WsbIXJDhC_o?si=ewf2ldYzk3gbVdNo Nope, I Tried it , as i mentioned i have large data, this method is dowloading only 3000 rows out of 70000, as number of columns are big like 88 columns
- Idrissshatila
babban ,
but this method downloads 100,000 rows, so there's something you're doing wrong if its only getting 3k.
Its probably because my number of columns are large which exhausts the limit of data size
- Idrissshatila
babban ,
but is there any user that would need an 88 columns to look at, try taking the columns that you won't need.
I need them all , its a report, otherwise i would have found the solution 🙂
SaiTejaTalasilaHi babban ,
You can refer what ever Idrissshatila shared.If you have issues in importing data 88 columns.I have an idea -1.Add index column to your power bi table 2.You can create 4 flows to import 23 columns. 3.Later on you can try to join/merge those tables data.
I never tried this approach, and I hope it will be helpful.
Thanks,
Sai Teja
