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.
como puedo hacer para que cuando se modifuqe o agregue informacion en la base datos en Excel automaticamente se actualize la base de datos en Power Bi
Ya tengo la actualizacion programada en Power Bi pro solo me permite poner 8 hr diferens como maximo
Solved! Go to Solution.
Hi @Anonymous ,
You could put the Excel file into OneDrive. Then once the file is updated. The data will automatically changed by every one hour in Power BI. You could check the result in refresh history.
Here is the document you can reference : Data refresh in Power BI
Or you could try to use Real-time streaming in Power BI to implement real-time refresh.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You could put the Excel file into OneDrive. Then once the file is updated. The data will automatically changed by every one hour in Power BI. You could check the result in refresh history.
Here is the document you can reference : Data refresh in Power BI
Or you could try to use Real-time streaming in Power BI to implement real-time refresh.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
How can I do it so that when the information is modified or added to the database in Excel the database is automatically updated in Power Bi I already have the update scheduled in Power Bi pro only allows me to put 8 hr different at most
Proud to be a Super User!
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 |
---|---|
107 | |
106 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |