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

how to change datasource after importing local PBIX in PBI Online

I have created a PBIX file going against a particular datasource. It goes against a fixed model in an Analysis Service. Now, I want to allow a customer to upload this PBIX file and customize it to point to their datasource, which will go against the same model also in Analysis Service - but for a different deployment. I need them to be able to change the datasource in PBI Online. However, I don't see a way how to do this. Is there a way to change the datasource in PBI Online?

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: how to change datasource after importing local PBIX in PBI Online

Hi @roalexan,

From what I know, there is no option to change the datasource in PBI Online directly. After research, you can share the .pbix file to customer if there sample data structure is same with yours, then let them change the dataset connection in Power Query. More details, please review this article: Power BI–Change of Data Source Settings got easier.

Another way to change the connection string by Power BI Rest API, but it's more complex and only supported in DirectQuery model, please review this similar thread.

Best Regards,
Angelia

Highlighted
Microsoft
Microsoft

Re: how to change datasource after importing local PBIX in PBI Online

Hi @roalexan,

Please mark the right or helpful reply as answer. More people will benefit from here.

Thanks,
Angelia

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors