cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leschi
Frequent Visitor

Access .pbix file with .NET software

Hi,

 

is it possible to access .pbix files with an .NET program?

 

I want to programmaticly change datasources and add tables. 

I do not want to show the visuals in my software.

 

Does someone have an idea if this is possible?

 

Many thanks,

 

Leopold

1 ACCEPTED SOLUTION

Hi @leschi ,

 

The PBIX file as a collection of files and folders in a compressed zip package. If you need to manually view the contents you can rename the ".pbix" extension to ".zip" to create a .ZIP file and then extract the contents of the file.

 

Currently there is no such functionality from powerbi to access/modify the pbix file programmatically from dotnet. 

 

If you want you can request this idea in the idea forum

View solution in original post

3 REPLIES 3
Jayendran
Solution Sage
Solution Sage

Hi @leschi ,

 

Yes you can achive that using a PowerBI REST API

 

  1. Changing the data source- Use Update PBI DataSource API
  2. Creating Tables: Put Table using Push DataSet API*

 

*Push datasets API -You can only use this API against the datasets created via REST APIA normal dataset published from PBI desktop doesn't support this.

leschi
Frequent Visitor

Hi @Jayendran , thanks for your answer.

But I want to change my File which i have stored on my computer not on PowerBI Online.

 

Do you have another idea?

 

Hi @leschi ,

 

The PBIX file as a collection of files and folders in a compressed zip package. If you need to manually view the contents you can rename the ".pbix" extension to ".zip" to create a .ZIP file and then extract the contents of the file.

 

Currently there is no such functionality from powerbi to access/modify the pbix file programmatically from dotnet. 

 

If you want you can request this idea in the idea forum

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!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors