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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors