Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JZrgNd
New Member

Sharing .PBIX files between users with different Bit computers

Hi.

 

I have searched on internet and forums for a solution for a problem. It seems that we have a different situation than most of the PowerBI users. We have a numbers of customers which all use the same database model for PowerBI. Due to privacy reasons we use direct query mode and our customers don’t see each other’s data and they all have their own database on a different location.

 

But our customers want to share the reports (.pbix files) with each other. Is there an easy way where our customers can use reports made by another customer and publish them from their own PowerBI desktop to their own PowerBI App in the cloud? It seems that changing the datasource of a report is not working for them (maybe it is possible, but not that easy). What are your suggestions for this situation?

 

Thanks in advance!

1 ACCEPTED SOLUTION
lndnbrg
Resolver III
Resolver III

Maybe this will help you: https://guyinacube.com/2017/09/parameters-templates-power-bi-desktop/

As Eno1978 pointed out, a template may solve your problem, because it will not save any data with the pbix file and you can use the parameters to ask for customer specific settings.

View solution in original post

4 REPLIES 4
JZrgNd
New Member

Indeed, they don't want to share data but want to share the layout of the report.

It seems that your solution works for our situation!

Thank you for responding!

lndnbrg
Resolver III
Resolver III

Maybe this will help you: https://guyinacube.com/2017/09/parameters-templates-power-bi-desktop/

As Eno1978 pointed out, a template may solve your problem, because it will not save any data with the pbix file and you can use the parameters to ask for customer specific settings.

@JZrgNd I might not understand the question, but it sounds like a scenario in which customer A builds a report and customer B wants to use the same layout to see their data in. NOT that customer A wants to share their data with customer B... accurate?

In the above case, as long as the datasets are the same in both databases, this should work. If it won't in the prompts, I would suggest making the changes to the M code directly in the advanced editor. Another option would be to have Customer A save their PBIX as a Template, that might ease the transition.

What errors is Customer B seeing?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

I would also check out this solution: https://powerbi.tips/2017/03/using-parameters-to-enable-sharing/

Mike Carlo ( https://powerbi.tips )
mike@PowerBI.Tips

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors