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.
Excel file which is in one drive when i connect this excel file to power bi desktop and published to power bi service. Will data refresh happen automatically when excel file is getting refreshed by macros?
Solved! Go to Solution.
But here, i have taken excel file from one drive and created reports in desktop and published using service.but the dashboard is not refreshing hourly and only i can refresh once in a day ( am using Power BI free)
Hi @kalpana,
Yes, the dataset will update the data hourly by default for the onedrive file datasource. It uses information in the dataset to connect directly to the data sources to query for updated data it then loads into the dataset.
Regards,
Charlie Liao
But here, i have taken excel file from one drive and created reports in desktop and published using service.but the dashboard is not refreshing hourly and only i can refresh once in a day ( am using Power BI free)
Covering 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 |
---|---|
113 | |
97 | |
85 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |