cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pozzyal Member
Member

Change data source for visuals

How do I change the data source which is feeding a visual? To clarify, I've learned how to do this:

 

I have visual1 and datasource1 and datasource2. visual1 uses datasource1, so I go into datasource2, click advanced settings, copy the code, so that datasource1 becomes datasource2.

 

But that's not what I want to do. I want to preserve both datasources as they are, and simply point the visual to datasource2.

 

This is such a simple thing and is essential, so I'm sure it can be done easily, but I can't figure out how. Can someone please help?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Change data source for visuals

Hi @pozzyal,

 

If you can confirm these query tables has same data structure, you can try to parametrize these query tables' connection string as query parameters.

 

After above operations, you can simply switch datasource by edit on 'query parameter' and 'apply change' to load new data from different data sources.

 

Before change:
visual A -> table1 -> datasource 1 ->connection string parameter 1
visual B -> table2 -> datasource 2 ->connection string paramerter 2

 

Modify parameters:

visual A -> table1 -> data source 2 -> connection string parameter 2
visual B -> table2 -> datasource 1 -> connection srtring paramerter 1

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Change data source for visuals

Hi @pozzyal,

 

Not really sure if I understand your question, you refer that you have 2 datasource and want to create the 2 similar visuals with both datasources, then you refer that you do an advance settings and copy the datasource 2 over datasource 1 (this is where I get lost).

Visual don't have advance settings, query's have them.

 

Are you refering to the formatting of the visual? if that is the case you just need to create the two similar visuals fill them with vthe information from their respective datasources, and then use the paint icon to copy the format from one to the other.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




pozzyal Member
Member

Re: Change data source for visuals

Thank you for the quick reply! I'll try to describe the situation again, in a similar way:

 

I have visual1, which is "connected to" datasource1.

 

I now have a second datasource - datasource2.

 

All I want to do is have datasource2 now be the source data for visual1, but I don't want to do anything to touch or change datasource1, as I may need it in other places.

 

Basically, I want to change the datasource which is attached to a visual, rather than changing anything about the datasource. This seems so simple, it must be possible?

 

thanks

Alex

Super User
Super User

Re: Change data source for visuals

Hi @pozzyal,

 

If you want to change the full datasource connected to a visual you need to create a new visual, you cannot have 1 visual and two datasources at will because visuals are based on context and context is given by the datasource.

 

Don't know the full setup of you model, but if those two visual have a dimension table in common that is also used in the visual you can use a switch formula and a filter to change the values on the visual to datasource values 1 or two.

 

But there is no way of changing the datasource without adding a new visual or changing manually the source in the specifi visual.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Community Support Team
Community Support Team

Re: Change data source for visuals

Hi @pozzyal,

 

If you can confirm these query tables has same data structure, you can try to parametrize these query tables' connection string as query parameters.

 

After above operations, you can simply switch datasource by edit on 'query parameter' and 'apply change' to load new data from different data sources.

 

Before change:
visual A -> table1 -> datasource 1 ->connection string parameter 1
visual B -> table2 -> datasource 2 ->connection string paramerter 2

 

Modify parameters:

visual A -> table1 -> data source 2 -> connection string parameter 2
visual B -> table2 -> datasource 1 -> connection srtring paramerter 1

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 288 members 3,224 guests
Please welcome our newest community members: