Forum Discussion
Error refreshing Composite model live connection to Power BI dataset
I have a composite model that combines a direct query to a Power BI dataset in the service with imported data from Excel/dataflow. When I try to refresh in the service to re-import the non-live data ...
Hello, In my case I am trying to aggregate multiple data sources into one with live connection. So can't avoid calculated table (using UNION in this case) in the final dataset. Any work around? I have confirmed that refresh works if I remove the UNION table from final dataset. Any insight to the error and if anything can be set in tenant or capacity to make this working?