Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I craeted a query for source system, so when I migrate my code to different env I don't have to change source for each table one by one, becuase I have over 10 table in the model. Database is Oracle
Query 1:
let
Source = Oracle.Database("orcl")
in
Source
I'm trying to call above query trying to use follwing query for each table (Facts is a table name), so when I migrate to production, all I have to do is change the Query 1.
let
Source = Oracle.Database(Query1.Fact)
in
Source
But I'm getting error:
Expression.Error: The name 'Query1.Fact' wasn't recognized. Make sure it's spelled correctly.
What am I doing wrong here? or is there a better approach to migrating code from one env to another?
Thansk in advance.
Solved! Go to Solution.
Hi @Anonymous,
If I understand you correctly, you should be able to change your data source under Data source Settings which could be easier in this scenario.
The second option to open the settings dialog is contained in the “Edit Queries” toolbar item menu.
Regards
Hi @Anonymous,
If I understand you correctly, you should be able to change your data source under Data source Settings which could be easier in this scenario.
The second option to open the settings dialog is contained in the “Edit Queries” toolbar item menu.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |