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

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 6 members 2,586 guests
Please welcome our newest community members: