Forum Discussion

SoulCuber's avatar
SoulCuber
Frequent Visitor
9 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

SoulCuber Either you started by using the "import" connection type, or you have another data source you are connected to. In either case, you need to open a new Desktop file and start over if you were using "Import" because you can't change from import to DQ.

You CAN change from DQ to Import, but that is the only direction that is accepted.

SoulCuber's avatar
SoulCuber
Frequent Visitor
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.