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.
hi
im working on making my tables partially depentent on a parameter
so the normal sql in advanced editor looks like this
let
Source = Sql.Database(SQLServerName, DatabaseName),
#"dbo_CRONUS JetCorp UK$Customer" = Source{[Schema="dbo",Item="CRONUS JetCorp UK$Customer"]}[Data]
in
#"dbo_CRONUS JetCorp UK$Customer"
and it work fine, then i would like to add a parameter for the "CRONUS JetCorp UK in the item part, because i also have a US version.
so for that i made a sql like this
let
Source = Sql.Database(SQLServerName, DatabaseName),
#"dbo_CRONUS JetCorp UK$Customer" = Source{[Schema="dbo",Item=(#"Company Name")&"Customer"]}[Data]
in
#"dbo_CRONUS JetCorp UK$Customer"
but it does not work 😕
my parameter is setup like this
hope one of you can help, because i cant seem to find the answer.
Solved! Go to Solution.
@Anonymous Not able to replicate the error. Tried the same and working fine. Please post any error that you are facing after changing the table name in the parameter (which is Company Name in your case).
Proud to be a PBI Community Champion
Hej
in my advanced editor i have this sql
let
Source = Sql.Database(SQLServerName, DatabaseName),
#"dbo_CRONUS JetCorp UK$Customer" = Source{[Schema="dbo",Item="CRONUS JetCorp UK$Customer"]}[Data]
in
#"dbo_CRONUS JetCorp UK$Customer"
so i have created a parameter, and my end result should look something like this
let
Source = Sql.Database(SQLServerName, DatabaseName),
#"dbo_CRONUS JetCorp UK$Customer" = Source{[Schema="dbo",Item=(#"Company Name")&"Customer"]}[Data]
in
#"dbo_CRONUS JetCorp UK$Customer"
so i dont need to tell power bi everytime what company the table comes from, but that this is a parameter, and then the tabels name??
i dont seem to find any answers when googleling this, hope you guys can help.
@Anonymous Not able to replicate the error. Tried the same and working fine. Please post any error that you are facing after changing the table name in the parameter (which is Company Name in your case).
Proud to be a PBI Community Champion
thank you for your answer, and you are correct i can actually see that i made a spelling mistake and my original solution actually did work, so i have you to thank for, that my method was right and therefore something else was wrong.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |