cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rzavgazaryan
Helper III
Helper III

Leveraging PowerShell to copy a Table in Power BI Desktop | Is this possible?

Hey folks - relitively new to PowerShell, but have been creating Power BI reports for a little while now. Here's my situation:

 

I have a colleague who does not have a VM, but created APIs via Python to bring in a bunch of data, and because he does not have a VM, he has to manually hit the refresh button on the PBIX file and republish to service once a day. This is all data regarding employee utilization.

 

Again, I am new to PowerShell, but would love to learn how to go about doing the following operation:

 

1) Navigate to SharePoint folder with PBIX File

2) Open that PBIX file

3) Copy 1 Table like so:

rzavgazaryan_0-1631111150882.png

 

4) Open Excel, paste the table into new excel worksheet:

5) Save to OneDrive/SharePoint location

 

Is something like this possible? I know this is a very specific use case, but if anyone has any insights here, I'd appreciate any pointers.

 

Ps: My colleage had shared the dataset with me through Power BI service .. Am I jumping through unnecisary hoops here?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@rzavgazaryan , there is code on how to export from table to sql server using python, you can try for SharePoint

https://pawarbi.github.io/blog/powerbi/python/sql/export/2020/06/23/export-powerbi-sql-python.html

 

or explore power automate

 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @rzavgazaryan 

Try using Dax Studio. https://daxstudio.org/documentation/features/export-data/

By the way, how about using python? you can take this viedio for reference, hope it helps.

vxiaotang_0-1631504021902.png

vxiaotang_1-1631504126263.png

https://www.thebiccountant.com/2018/12/29/export-data-from-power-bi-to-csv-using-python/

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@rzavgazaryan , there is code on how to export from table to sql server using python, you can try for SharePoint

https://pawarbi.github.io/blog/powerbi/python/sql/export/2020/06/23/export-powerbi-sql-python.html

 

or explore power automate

 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!