Forum Discussion

dobregon's avatar
dobregon
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

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!

 

5 Replies

  • Anonymous's avatar
    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's avatar
      dobregon
      Icon for Impactful Individual rankImpactful 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