How to Setup Multiple On-Prem Databases to Then Bring Data into Onelake
Hi there, I have just enabled the Fabric trial for my organisation and I am attempting to bring our clients data into Onelake to report off. I am very new to all this, hence looking for some guidance. This client has three sites (NZ,AU,US) and we support their on-prem ERP software. This software uses a Firebird database, therefore I am using the ODBC connector on each server. My questions are: 1. Do I need to RDP into each server, open Fabric through a browser and bring in the tables I need to Onelake via ODBC & connect the on-prem Gateway for LIVE refresh? 2. Once i've done this, can I then access all the data from my local PC within Powerbi desktop to create their reports? 3. Why does the OBDC connector bring in the data initally, then the on-prem application allow it to refresh live? What is the difference between these applications? I made this diagram just to get my head around it, can anyone tell me is this correct? If anyone has extra advice around this, it would be so greatly appreciated! Thank you!
Daily Phone Call Report
Hello community, this is my very first question about PowerBI. I'm trying to create a report that shows how many call are being made by a SDR day by day to make a comparative clustered column chart. I'm using 3 columns from my phonecall table which comes from a Direct Query to our CRM (Dataverse) so i know there are some inherit limits with that. For my x-axis i have "Actual End" Column. For my y-axis i have "count of statuscodename" I tried distinct and still not working. And the legend is the "Owner" My question is, what I'm missing and why my graph is displaying multiple bars. Thank for all and have a great day!
Formula - Circular dependency - Cumulative Sum?
Hello! (Not sure if it's okay to post it here but I really need some help) I need to make some measures where they are dependent to each other. But PowerBI says that I have a circular dependency So I tried to find a way to make it not dependent but I can't seem to get it. Here's the sample data: 1st month of the beginning cash is a fixed value (I'm good with this, planning to have a parameter?) 1st month of the ending cash is current beginning + cash flow. 2nd month of beginning cash is last month's ending cash. 2nd month of ending cash is current beginning +cash flow. And so on and so forth. Beginning and Ending Cash are dependent. I'm thinking of having another measure, True Cash, that will compute for the cumulative cash total. But I have no idea also on this part. Also, my Cash Flow is a calculated measure. Any help is appreciated. Thank you!
