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