cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Sending reports( .pbix ) automatically for differents Organizations

Hello everybody, I would like to know if there is any option that allows me to send my reports ( .pbix ) to the web automatically for various organizations ... Is there any way for me to make this process ?

Is there an API for Power B.I in this regard ?

I have several organizations and I need to send the same report to ALL of them , each one has a different domain ...

Thank you guys!! Hugs!

1 ACCEPTED SOLUTION

Accepted Solutions
ankitpatira Super Contributor
Super Contributor

Re: Sending reports( .pbix ) automatically for differents Organizations

@brunozanoelo If you want to publish pbix files fro different clients into their power bi service without using power bi desktop I think your only option currently is to leverage Power BI REST APIs. Check out this page on the list of available operations with power bi rest apis and the one that you would need is this (Import PBIX) where you can programatically authenticate account for each of your client and then publish it to their workspace.

4 REPLIES 4
ankitpatira Super Contributor
Super Contributor

Re: Sending reports( .pbix ) automatically for differents Organizations

@brunozanoelo The approach you should be taking is create power bi template file that you can distribute to different clients. Check out this article that shows how to create temple and distribute templates.

Re: Sending reports( .pbix ) automatically for differents Organizations

@ankitpatira ! Smiley Very Happy
Currently I work in a company which is contracted to make report creation service for some companies. Our goal is to develop a report that can be used by several companies without having to make customizations, because each client of ours contains the same database structure. But each company has NO relationship with the other, are distinct companies, the data is different.

Structure of the tables?
All of our customers contains the same database structure, so the created datasets can be used by any client, the tables are the same.

How to update data by automatic update?
As the connection is made by ODBC, if each client uses the same NAME ODBC driver on the computer that will perform the update with DataGateway, seeing that, we will have no problem if the server that contain the DataGateway will have the ODBC Driver with the same name as that on but 'pbix' file, but with a location for the Database that is on your local server.

Example: PBIX File on power bi:
ODBC NAME: POWERBI_FIREBIRD

Company A (ODBC Driver Setup in the computer with DataGateway)
ODBC NAME: POWERBI_FIREBIRD
BD Localization: localserver/C:/EMPRESA1/BD1.FBD

Company B (ODBC Driver Setup in the computer with DataGateway)
ODBC NAME: POWERBI_FIREBIRD
BD Localization: localserver/D:/EMPRESA2/BD1FBD

The problem is that as the power of bi accounts are different, one having nothing to do with the other.
I would like to create a report and publish it in each account in an automatic way.
If I have 50 clients, and a new report is created, I have to send this report to 50 different organizations in the Power BI for them to start using.

How can i do that? The tool with Power BI Desktop is one by one publish.

ankitpatira Super Contributor
Super Contributor

Re: Sending reports( .pbix ) automatically for differents Organizations

@brunozanoelo If you want to publish pbix files fro different clients into their power bi service without using power bi desktop I think your only option currently is to leverage Power BI REST APIs. Check out this page on the list of available operations with power bi rest apis and the one that you would need is this (Import PBIX) where you can programatically authenticate account for each of your client and then publish it to their workspace.

Re: Sending reports( .pbix ) automatically for differents Organizations

Thanks a lot for the help @ankitpatira!

Thank you very much for giving me all these tips and helped me understand even more the tool.

I'll check the API and deeper into the matter !

Grateful for the attention!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 144 members 1,910 guests
Please welcome our newest community members: