cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cher90
Helper II
Helper II

Referenced tables do not update after changing the data source!

Hello!

 

What I want to do ?

 

Change data source and resynchronize my dataset with the new data source.

 

What I have done :

 

I had a dashbord in power service (premium per user) which worked with data source 1 (postgres), a migration was made to a more recent postgres and I therefore had to change the data source to data source 2 (postgres ).

 

My dataset contains tables that come directly from data source A and B and other tables that I created myself

A1 which is a reference of A and B2 which is a reference of B. All the tables are configured with the incremental refresh and everything worked well.

 

First I changed the data source in power bi desktop then I used ALM toolkit to update my dataset in Power BI service.

 

My problem after changing to data source 2:

 

Tables A and B update without problem but A2 and B2 do not update, I get this error via SSMS :

 

 

 

Erreur de source de données: Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface.
URI du cluster: WABI-FRANCE-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
ID d'activité: 1b80197f-a8b4-40fe-b967-7b141b0749f3
ID de demande: 4d076e87-414c-40fe-b7e2-ec7a2dbf946d
Heure: 2022-12-02 01:46:09Z

 

Any idea of the source of the problem please? Why these referenced tables do not update.

 

 

 

1 ACCEPTED SOLUTION
djurecicK2
Memorable Member
Memorable Member

Hi @cher90 ,

 This article might be helpful to you:

https://excel-start.com/power-bi-error-information-is-needed-in-order-to-combine-data

 

Please accept as solution if this answers the question- thanks!


If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
djurecicK2
Memorable Member
Memorable Member

Hi @cher90 ,

 This article might be helpful to you:

https://excel-start.com/power-bi-error-information-is-needed-in-order-to-combine-data

 

Please accept as solution if this answers the question- thanks!


If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

Hi djurecicK2,

 

Thanks a lot.

 

But I'm looking for a solution without re overwriting the report that there is in Power BI service.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors