Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Can't schedule refresh 2 appended data base in the Query Editor

Hello,

 

I m trying to set-up schedule a PBI model but it won't work because he can't find the data base that I created using 2 different CSV files inside the query editor.

 

I've put the correct source of each of those 2 files but it seems that the PowerBI Service can't reproduce what was made inside the query editor,... So he can't find this "new table". (The rest of the model is updating, only this part is showing an error)

 

Any ideas?

 

Regards

 

Mark Lovejoy

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Well I delete the dataset and republish it and now it working. I started with file stored on local server, then local one drive file and finally web one drive URL. Power BI probably got crazy with all those changes.

     

    Thanks for your time and help :-)

     

    Mark

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Mark,

     

    I had same issue with merging query.

     

    Did you appended query or appended as new query?

     

    If you have just appended to one of the tables then PBI service will give you error.

     

    BR

    //Rasty

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Rasty,

       

      thank you for your reply, I appended as new query.

       

      But since it a new query, I think the problem is coming from this

       

      Source = Table.Combine({#"Argo entries Final modèle", #"Integra entries final modèle"})

       

      As you can see it is not taking the source I m providing on the service sicne the source are the 2 tables.

       

      Have you been able to resolve the issue? By appending query (not as new)=

       

      regards

       

      Mark Lovejoy

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Mark,

         

        I am using also 2 types of connections where I made merge.

         

        Using HANA and excel from sharepoint. I had only issue when I have merged hana into excel table.

         

        But when I have merged as new query, it's working perfectly.

         

        Try to use below, looks like you had one "#" extra before first table

         

        Source = Table.Combine({"Argo entries Final modèle", #"Integra entries final modèle"})

         

         

        //Rasty