Refresh PBI problem in service

[dobregon]

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!

[Anonymous]

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]

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

[v-yiruan-msft · 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

[dobregon]

thanks @v-yiruan-msft this works!

[Greg_Deckler]

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".