Showing results for 
Search instead for 
Did you mean: 
anilsaini Frequent Visitor
Frequent Visitor

Export Power BI datasource from Powerbi desktop

Hi Experts,


I want to share the data source on which some of my reports are build to one of my colleagues.


We don't that the next person will again make the connection with the data source, specify joins and create a dataset ready for creating reports.


Is there any way to export my data source ( connection detail with actual data) so that if I share that file, he need not create connections etc again. 

Community Support Team
Community Support Team

Re: Export Power BI datasource from Powerbi desktop

Hi @anilsaini,


If you want your user to get your data source without any credential, it should be impossible in Power BI. The identity authentication is for security.


If you want your next person could create the report with your dataset, you could create an app workspace in Power BI Service and add your colleagues as the member in it, then publish your report to the app workspace. Your user could connect with Power BI Service and select the report you have published in the app worspace without connect the underlying data source.


Note: you should give the edit permission of the workspace.


If that is not your case, could you describe your scenario in more details so that we can help further investigate on it?


Best Regards,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
anilsaini Frequent Visitor
Frequent Visitor

Re: Export Power BI datasource from Powerbi desktop

@v-piga-msft Thanks for you answer, Yes, I want to do it with security.


Yes, what you mentioned is correct. But I do not want to do it via Power BI service. Is there any similar way of doing that using powerbi desktop.



Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 64 members 1,407 guests
Please welcome our newest community members: