Power BI Folder Refresh Setup
Budget: $10 – $30 USD
I already have a working PBIX file, but I have new excel in a whole folder of Excel workbooks as a new to add into existing consolidated data source. Your job is to connect that folder, build the proper query in Power Query so every file inside it is ingested correctly, and then refine the model relationships so the new tables interact cleanly with the ones that already exist.
Once the model is solid, I also want the report published to the Power BI Service with an automated daily refresh schedule, so the moment a new Excel file drops into the folder the visuals update without manual intervention. I will provide the current PBIX and access to the workspace; you return the updated PBIX plus a short note confirming the refresh is running in the service and the visuals reconcile with a test dataset.
Please advice on the Power BI report Buider template to extract my current PBIX as sales by vendor template.
Requirement
1. current using folder method to have multiple data as dataset
2. with same dashboard i need added new table as supplier and Purchase
3. Build Relationship for the 3 table
4. In the matrix i need to have a item code and Item description side by Side
5. How to set to have auto refresh and publish
Once the model is solid, I also want the report published to the Power BI Service with an automated daily refresh schedule, so the moment a new Excel file drops into the folder the visuals update without manual intervention. I will provide the current PBIX and access to the workspace; you return the updated PBIX plus a short note confirming the refresh is running in the service and the visuals reconcile with a test dataset.
Please advice on the Power BI report Buider template to extract my current PBIX as sales by vendor template.
Requirement
1. current using folder method to have multiple data as dataset
2. with same dashboard i need added new table as supplier and Purchase
3. Build Relationship for the 3 table
4. In the matrix i need to have a item code and Item description side by Side
5. How to set to have auto refresh and publish