Accidentally Dropped Azure SQL Table - Need to Update AAS Table Connection

Mariah 136 Reputation points
2021-10-08T02:28:18.99+00:00

I dropped and recreated a view in Azure SQL. I do not want to drop and recreate the table in AAS otherwise some dashboards that have a live connection to AAS will break. Is there a way to point the AAS table to the new view?

Because the new view has the same name as the old view, will AAS just pick up the new view? (The new view has 1 extra column).

I've looked into trying to find the DataSourceId, but I cannot find the xml. (here)

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
0 comments No comments
{count} votes

Accepted answer
  1. Mariah 136 Reputation points
    2021-10-08T16:02:15.993+00:00

    I figured it out! I followed the section "To add a column from the data source by using the Edit Table Properties dialog box" on this page. (You can right click on the table name in Tabular Modular Explorer > click Table Properties > Design > login if need be and click "Import" in the upper left of the Power Query editor.)

    Just like the article says, I imported the new column into the AAS model (& table) by clicking "Import" in the power query editor. I then redeployed the model..and it worked! Power BI now has the new column and the dashboard didn't break.

    TLDR; there is a way to not break the dashboard with schema updates :)

    0 comments No comments

0 additional answers

Sort by: Most helpful