BoazY
9 years agoRegular Visitor
Status:
Needs Votes
Load Data Dynamically - (Generally & For Priority)
I work with the program "Priority". Each customer has a database. In each database, there are a few companies belonging to one customer. Priority is structured such that each company has the same exact tables. There is a specific table that lists for each customer's company names. I would like to load data dynamically such that I can enter in a variable the name of the company, for example the custome's name is CDSE#, custome's name is AAA, and if its a query in SQL, the row labeled "FROM" would be FROM CDSE#AAA.dbo.DOCUMENTS--this is in the case that the variable WWW would look like FROM CDSE#WWW.dbo.DOCUMENTS. Therefore for each table, such as "DOCUMENTS", i need to change CONNECTION such that the variable WWW would receive now the name of the next company after one LOOP of uploading, so on and so forth, until the entire DOCUMENT table is filled for all the companies belonging to one customer, and in each LOOP, it would add a key of the company to the table.
2 Comments
- przemek_pbiRegular VisitorHi Boaz Y, did you manage to bypass this limitation?
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Enhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy11 minutes agoRegular VisitorNew1View0likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db4 hours agoNew MemberNew238Views2likes2CommentsReintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku7 hours agoNew MemberNew106Views14likes1CommentSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull229 hours agoAdvocate INew12Views1like0Comments