Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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?
Solved! Go to Solution.
@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
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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |