Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dobregon
Impactful Individual
Impactful Individual

Refresh PBI problem in service

Hi guys,

 

I'm having some problems when i tried to refresh my dataset in the powerbi service. I have my dataset in the powerbi desktop with around 10-12 tables from a database. In the powerquire i have some tables that takes combinations from other with merge queries, etc.

 

The problem is that in the PBI desktop i can refresh the tables without any problem but when i publish into the powerbi service and click to refresh i receive the following error "Information is needed in order to combine data Table:..."

 

I have tried to disabled the option "enabled parallel loading tables" but this dont solve the problem.

 

Can someone helping me on that?

Regards!

 



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
1 ACCEPTED SOLUTION

Hi @dobregon ,

This problem may be caused by the privacy level setting. You can refer to the solution in following case and check if it can solve your problem: https://community.powerbi.com/t5/Service/Information-is-needed-in-order-to-combine-data/td-p/574058

 

Best Regards

Rena

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

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Open the same .pbix file via PBI Service (i.e. PowerBI.com --> GetData), and the dataset connection will be updated. Credentials can now be set without error, thus allowing scheduled refreshes to be set. 

This will help you to refresh the Power BI service problem.

dobregon
Impactful Individual
Impactful Individual

there is not a problem in the credentials or gateway. it is something that affect the merge queries in the powerbi services. but not all the merge queries that i have, so for that reason it is strange for me.

 

If i deleted the merge querie in the table that the system said to me the probelm... the system refresh well



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Hi @dobregon ,

This problem may be caused by the privacy level setting. You can refer to the solution in following case and check if it can solve your problem: https://community.powerbi.com/t5/Service/Information-is-needed-in-order-to-combine-data/td-p/574058

 

Best Regards

Rena

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

thanks @v-yiruan-msft this works!



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Greg_Deckler
Super User
Super User

What do your queries look like?

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.