Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

@Anonymous , 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

 

 

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @Anonymous 

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

@Anonymous , 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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.