Forum Discussion
Append query failing refresh when published
I have a PBI Report with 2 data sources (onprem SSAS; azure sql server). Both are set up in import mode and gateway has been set up for the on-prem source. This report can be published into PBI servi...
GilbertQ thank you for the quick reply. When I get some time over the next couple of days I'll investigate trying this. Not used powerquery before but I'm sure I can give it a go. Also, you mentioned privacy settings, is this something on the gateway that is preventing the append from succeeding?
Privacy settings apply to a datasource in Power Query. You can check that here: