cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dobregon
Post Prodigy
Post Prodigy

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
yingyinr
Community Support
Community Support

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.

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)
yingyinr
Community Support
Community Support

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 @yingyinr 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!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors