User Profile
kevin_oleary
Regular Visitor
Joined 1 year ago
User Widgets
Contributions
Schedule Extract from Web App to Push to Fabric Data Warehouse
Hello! I am new to fabric as well as all of the other devs/data engineers for the company. We are planning on setting up a data warehouse within fabric to improve scalability of our growing company and I am tasked with researching the process. Our devs are adamant that they do not want fabric to PULL data from our DB into the data warehouse, rather we would like to schedule a data PUSH from our own web app to Fabric. Currently our web app has the capability and is optimized to push data (ad-hoc or on a schedule) to an FTP server or send a data file to an email destination. I have tried researching here on the forums and elsewhere on the world wide web if Fabric Data Warehouse can act kind of like an FTP server, where we can push a file to it that we schedule from our web app, but I am seeing a lot of results that appear more like Fabric would pull data from our DB on a schedule that we set up through a data pipeline in Fabric. Is it possible to treat the fabric data warehouse like an FTP server for the sake of pushing data to it? If so, how do I go about setting that up? If it helps, our web app is hosted in Microsoft Entra. Any help is greatly appreciated, thank you!Solved2.1KViews0likes7CommentsRe: How to add a new column based on a condition from a separate reference table?
Thank you for your response! I am still learning the ins and outs of PowerBI, so I am definitely saving this for the future so I can write my own Power Queries on later problems/issues that I encounter.975Views0likes0CommentsHow to add a new column based on a condition from a separate reference table?
Hello! Thanks in advance for any help you can give me. I am new to Power BI and so far I am enjoying it, especially for the ease of connecting straight to our company's DB. I have multiple tables in my data, I have identified all of the relationships between one another in PowerBI. At the moment I could use help with getting the columns I need in the way that I want for the sake of reporting. I am not comfortable putting my company's data out on the internet so I'm using a couple of quick sample tables. I have a Bills Table and a Fee table: Bills Table Bill Number Customer Total 1 A $ 450.00 2 B $ 275.00 3 A $ 640.00 4 C $ 120.00 5 A $ 915.00 6 B $ 385.00 7 C $ 290.00 8 B $ 150.00 Fee Table Bill Number Fee Type ID Fee Amount 1 10 $ 25.90 1 15 $ 64.30 2 10 $ 12.99 3 19 $ 16.47 3 15 $ 49.56 4 12 $ 27.95 6 15 $ 13.29 7 12 $ 84.50 I am trying to add a column to my bills table where BillsTable[BillNumber] = FeeTable[BillNumber], but I only want to bring in values from FeeTable[FeeAmount] where the [FeeTypeID] = 15. My desired output would be something like this: Desired Result Bill Number Customer Total Bill Add'l Fees (Fee Type ID = 15) 1 A $ 450.00 $ 64.30 2 B $ 275.00 $ - 3 A $ 640.00 $ 49.56 4 C $ 120.00 $ - 5 A $ 915.00 $ - 6 B $ 385.00 $ 13.29 7 C $ 290.00 $ - 8 B $ 150.00 $ - Any and all help is appreciated thank you!Solved1.1KViews0likes5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.