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
Power BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor4 hours agoSuper UserNew3Views0likes0CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor4 hours agoSuper UserNew4Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell5 hours agoNew MemberNew3Views0likes0CommentsPower BI Desktop Data Load: Can We Get Better Progress Visibility?
One UX improvement I’d really like to see in Power BI Desktop is better visibility when loading large datasets from Power Query. Currently, when Power Query finishes processing and the data starts l...salmansaifee776 hours agoRegular VisitorNew16Views0likes0CommentsImprove support for calculated tables on remote semantic models
When a report is connected to a remote semantic model, Power BI Desktop allows users to create calculated tables and calculated columns based on that remote model. The issue is that this architectur...alaeddinegaaya10 hours agoNew MemberNew10Views0likes0Comments