Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

Power BI Park

Private • 213 • $39/m

15 contributions to Learn Microsoft Fabric
Connecting to on prem oracle database
Ok so stumbling at the first hurdle here, and hoping some of you might be able to help… I am trying to connect to an on prem oracle database. I am currently connected to the network via a vpn and am able to log in to the oracle client. My next step was to connect Power BI desktop to it and start looking at the data but can’t get this to work. I’m wondering whether this is an old 32 bit server or something. My ultimate goal here is to use a copy activity in a fabric pipeline to ingest the data into my lake house. Has anyone got any tips? This is my first time working with an oracle database and it’s very clunky to say the least.
3
5
New comment 29d ago
Any geospatial folks using Fabric + Azure Maps?
An interesting post from Johannes Kebeck (Group Program Manager - Azure Maps at Microsoft) on LinkedIn: " So many things you can do with Microsoft Fabric and Azure Maps: - From Event Stream over Event House into Real Time Dashboard to track your assets, - Reflex to send alerts when assets enter or leave a geofence, - Lakehouse Notebook and Azure Maps to determine speeding and perform other post-drive analysis. - ...or risk analysis with Lakehouse, Notebook and Azure Maps published into PowerBI for broader consumption. " Read more about Azure Maps. Is this something you're interested in/ implementing? Let me know your experiences! I can see this being a really useful use case for Fabric, for companies with a geospatial element
13
8
New comment Oct 31
Any geospatial folks using Fabric + Azure Maps?
0 likes • Oct 29
Interesting. I’m just starting a project to ingest IoT data from an engineering companies cnc machines. Was looking into azure maps and digital twins to visualise everything.
Pulling data from Azure DevOps boards
Has anyone achieved this outside of the connector which seems to be only available in power bi desktop. I want to configure a copy activity to pull data into my lake house about current work items etc.
0
4
New comment Aug 7
Get value from notebook and pass to next pipeline activity
I feel like this should be easier than it seems. I’m trying to build an api call in a fabric pipeline. I have a lake house with a delta table that has a column of ID fields. Id like to iterate over each one and use the value to build an api call (one api call for each value). I’m struggling with outputting the value to the next activity, I’m trying mssparkutils and lookup activity but I can’t seem to get it. Any ideas?
0
5
New comment Jun 10
1 like • Jun 7
@Will Needham Wow, that’s a proper workaround! Thanks I’ll save that one for future reference.
0 likes • Jun 7
@Will Needham I’m trying to aggregate the output of these api calls into a json file. Do you have any tips? I’m trying to use an append variable activity after my copy data activity but I can’t see how to turn off the destination in the copy data activity and send the output to the append variable activity
IT'S FRIDAY!! So share your Fabric Wins...
Learning Fabric is a marathon, not a sprint. So let's celebrate the small wins we make along the journey. Share any recent wins you've had with Fabric in the comments below! Perhaps this week you: - successfully shortcuted into Amazon S3? - built a Snowflake mirrored database? - learnt some new data modeling techniques? - build your first eventstream to process real-time data? LET'S HEAR ABOUT IT!
Complete action
2
18
New comment Jun 17
IT'S FRIDAY!! So share your Fabric Wins...
6 likes • Jun 7
I created a pipeline that looks up a list of company numbers in a Lakehouse table and iterates over each one to build separate API calls to the companies house website. The API then returns address details using a for each loop and saves them into another Lakehouse table.
1-10 of 15
Mark Maconnachie
3
35points to level up
@mark-maconnachie-4137
I am a Data Engineer

Active 9d ago
Joined May 6, 2024
London
powered by