Forum Discussion

wannarub's avatar
wannarub
New Member
2 years ago
Solved

Error while getting data from dataflow cross on-prem dataset.

Hi Everyone.

I've got some problem for my dashboard. The requirement for this dashboard is, I have to get data from dataflow then use it as a criteria when I select the data from on-prem server.


Example :

 

select a.*

from [on_prim_data] a

where a.id in (dataflow's data);

 

Just like this.

 

In the PBI desktop the process was success. but when I publish this dashboard to the server. When I try to refresh the dashboard, it's show error as :

 

And the “Gateway and cloud connections” setting as : 


Anyone please suggest. 

Dataflow
Need Help
  • wannarub's avatar
    wannarub
    2 years ago

    Hi Anonymous 
    Thank you for your attention and supports, and sorry for late reply.

     

    Now I can solved this issue. By use dataflow to get data to use as a criteria then create another dataflow to get data from on-prem server with these crireria.
    After that in dashboard will get both data by these two dataflows. Just about that.
    Thank you.

3 Replies

  • wannarub's avatar
    wannarub
    New Member
    2 years ago

    Hi Anonymous 
    Thank you for your attention and supports, and sorry for late reply.

     

    Now I can solved this issue. By use dataflow to get data to use as a criteria then create another dataflow to get data from on-prem server with these crireria.
    After that in dashboard will get both data by these two dataflows. Just about that.
    Thank you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi wannarub ,

       

      Glad to hear you solved the problem yourself!

       

      Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

       

       

      Best Regards,

      Clara Gong

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi wannarub ,

     

    It looks like your problem is caused by this part, if you can, please share more details about it so that we can better help you solve the problem.

     

     

    Also, these solutions may be able to help you.

     

    Solved: Gateway extenionDataSourceKind Power BI error - Microsoft Fabric Community

    Solved: How do I change the credentials for a Dataflow pul... - Microsoft Fabric Community

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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