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

[wannarub]

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. 

[wannarub · Accepted solution]

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]

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]

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.