topic Re: Access .pbix file with .NET software in Developer

Access .pbix file with .NET software

leschi — Fri, 17 Jan 2020 09:15:22 GMT

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

Re: Access .pbix file with .NET software

Jayendran — Fri, 17 Jan 2020 12:08:16 GMT

Hi @leschi ,

Yes you can achive that using a PowerBI REST API

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

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

Re: Access .pbix file with .NET software

leschi — Tue, 21 Jan 2020 07:46:46 GMT

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?

Re: Access .pbix file with .NET software

Jayendran — Tue, 21 Jan 2020 14:47:58 GMT

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