question

Mariah-0471 avatar image
0 Votes"
Mariah-0471 asked Mariah-0471 answered

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

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-databaseazure-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Mariah-0471 avatar image
0 Votes"
Mariah-0471 answered

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 :)


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.