pbi

2 Topics

Get xlsx file from website
Hi guys, I am trying to find solution how can i link external data source to PBI . In my case my data is .xlsx file located on web page, and i have several of them. So basically i need get excel files from web pulled in to PBI and have it automated, because this files refresh each day. i have this (did use custom name to protect source web page - name.something.com/admin file1_2023-01.xlsx file1_2023-02.xlsx file1_2023-03.xlsx file1_2023-04.xlsx file1_2023-05.xlsx
Alen1987
7 months ago Place Desktop
7.6KViews
0likes
5Comments
MS Fabric Incremental loading
I need help to understand the best practices for Incremental loading with AZURE and loading into Data Factory. I beleive there is two methods behind my use case but want to understand the route I should take and explore my options Use case: I'm in a smaller organization ( Around 400 people) and we want to build a central location for a reporting platform solution. We use Salesforce and QAD as our ERP. QAD is a little old but we are still able to connect to azure through ODBC. How and what prinicples should I be following for loading data from our ERP enviornment on a incremental cadence? Based off my understadning and knowledge, Should I (1) Use the copy data pipeline and use fucntions/ activities to update the table? how would I scheudle the job? How would this take into account for a heavy volume table? or (2) use notebooks throughout this process and set a datetime column as a water mark value to help with updates? How would I go around this method? I would apprecaite any information on how to handle this and best practices.... I do not have a SQL server available which I know which would help for the control table feature. Any suggestions, thanks
Solved
Fisayo99
2 years ago Place Desktop
6.6KViews
0likes
1Comment