Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a PBIX file which is using a local ODBC connection within an excel file. What is the best setup so that the odbc tables within the excel file can be auto refreshed before the PBIX refreshes on the service.
At the moment I am just working on the local desktop app but looking to publish the file and report online for auto refreshing
Power BI cannot cause Excel to autorefresh its internal connections.
Your best course of action is to get whatever Excel is doing and put it 100% into Power BI via Power Query and bypass Excel.
If you cannot do that, then you will need to visit the Excel forums and see how you can get an Excel file to open, automatically refresh, then save and close itself. I suspect you will need VBA for that to work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
20 | |
19 | |
18 | |
9 |