Forum Discussion
Data update via web UI
Hi folks, I built a report/dashboard in Power BI desktop and published it to the web. The report is linked to an Azure database. I shared the report to end-users who access via the web. After the...
Hi Anonymous, thanks for the reply. That was very helpful. I tried rebuilding my report from scratch with DirectQuery. However, various transformations are not allowed in DirectQuery mode. For instance, it does not accept "Append Query". It seems that I cannot build the reports I want in DirectQuery. Is this a fact or are there alternative ways? Look forward to hear your ideas...
SoulCuber Yeah, all the neat "Power Query" functions for data manipulation and transformation are disabled in DQ. The approach I take with DQ is to build views in the database. This allows me to 1) only pull the columns I need and 2) change the data to match what I want returned to make modeling easier. So the Views serve as the transform layer.