Forum Discussion
Fast Combine Enterprise Gateway
Hi Noam,
Based on my research, there is no Fast Combine concept in on-premise gateway currently. In your scenario, it seems that there are something wrong with combining data in the data model. I would suggest you open the report in Power BI Desktop, then open Query Editor, to check the steps applied in those tables which retrieve data from SQL Server and OLAP server. Please reorder or edit steps, and click refresh to check if the issue occurs.
If refresh is fine in Power BI Desktop, then republish the report to service. If those data source are not sensitive, you can set Privacy Level as Organizational for those data sources under the on-premise gateway.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft
Thanks for the awnser. In Power BI Desktop the import only works if I ignore the Privacy Level. The steps in the Query Editor are all correct. The error only started to ocure since we started to use the new query-parameters for the server names. I still need to check if the use of the parameters is the problem. I will test that soon and give here an awnser...
Regards
Noam