Forum Discussion

Gasho's avatar
Gasho
Regular Visitor
1 year ago
Solved

How to update all Queries in Power Query Editor

In Power Query Editor, I have bunch of Queries/Views  under Queries [10] that I would like to modify with one shot to replace schema 01 with schema 02 under Naviagation I created Parameter BAORAO02_...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    You can create a Parameter for Schema Name

    Name: SchemaName
    Value: "BAORAO02_Silo2" (or any other schema name)

     

    Or you can create a Central Function to Retrieve the Schema

    Go to Power Query Editor → New Query → Blank Query
    Open Advanced Editor and paste:

    (schemaName as text) =>
    let
    Source = Odbc.DataSource("dsn=ABC112", [HierarchicalNavigation=true]),
    ABC112_Database = Source{[Name="ABC112",Kind="Database"]}[Data],
    Selected_Schema = ABC112_Database{[Name=schemaName,Kind="Schema"]}[Data]
    in
    Selected_Schema

    Rename this query to GetSchema.

lbendlin's avatar
lbendlin
Super User
1 year ago

I'm getting an error message when dragging multiple tables to the TMDL view?

 

 

MarkLaf's avatar
MarkLaf
Super User
1 year ago

I'm definitely no expert and have only just started tooling around a bit with TMDL, so not sure what might be the issue.

 

I was able to duplicate a similar-looking set of errors by having my top table definition at a different indentation than my others.

 

Perhaps try dropping in fewer at a time to pinpoint what is triggering the indent messup?

 

It is in preview, so it could just have trouble performing with models beyond the very simple and small one I just tested with.