cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pozzyal Regular Visitor
Regular Visitor

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: | |
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 Regular Visitor
Regular Visitor

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: | |

Helpful resources

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.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 342 members 3,644 guests
Please welcome our newest community members: