Best Practise to share reports with our customer using their own dataset

[Haderach]

Hello,

We are an ERP editor. We have started to look at powerBI a couple month ago.

We have so many ideas to integrate it our solution but we have a major question before to continue to explore PowerBI.

We have created many report on our own dataset examples with our own data model.

Now we would like to share these reports to our customers authoring them to their own dataset with of course the same data model. What is the best way to this ?

Is the group sharing ? The organizational content pack ? Service content pack ? Another way ?

Thank you for helping us.

Read you soon.

[hubaz78]

I have the same issue and i am trying to simplify the update process and do the minimal effort to update these reports periodically.

My case is having identical clients DB instances and i want to use same report on different DB instance depending on the client accessing the report.

Technically, I am working on a combination of one data source, one report, multiple groups, multiple roles.

until now i am on testing that, i will update you with the results later when it succeed.

[Haderach]

@hubaz78

Did you find any solution ?

How did you manage to deploy sae report on different DV instance depending on the client ?

[ankitpatira]

@Haderach Not at the power bi service level but in power bi desktop you can leverage template and query parameters feature to build reports connecting to your data source. Then export it out as a template and send those templates to your client. Then open template in power bi desktop -> it prompts them to connect to their data source and reports gets displayed. Check out this blog post on how to do that.

[Haderach]

Thank you for you answer and sorry for response delay.

In fact, I already knew the solution you propose with the pbit (template) file.

My final goal is the publish these report with their datasource in order to embed them into our application. 

It is too long to open x times the pbix for x customer, connect to their data source, and republish them on each account.

Any other idea?

Thank your for your help !