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've read a lot about updating data automatically in Power BI but I still hasn't figured out how to make things work for me. So, here is my problem:
I have a report on my Computer, which I created in Power BI Desktop. In this report my data comes from 2 different Excel files. Everything (report and Excel Files) are saved in the same folder, in One Drive (saved in the OneDrive folder in Windows Explorer). Both my Data Sources were imported to Power BI Desktop through "Get Data" -> "Excel", choosing the file in the One Drive folder in Windows Explorer. Hence, the path to these files are "c:\users\my_user\OneDrive\...\filename.xlsx"
When the report was ready to go, I published the report in Power BI Service, through the "Publish" button. In Power BI Service, now I have my report and the dataset in my workspace, both named just like the .pbix file. I thought this Dataset was linked to my OneDrive files, so they would get update hourly, but when I click "Update Now" it prompts me saying I should set up a Personal or Business Gateway. Given what I've read, I think PowerBI service is recognizing my files as local files, not OneDrive files.
Given that one of the Excel files is updated daily, it'd be really nice to have it updated automatically on PowerBI based on my OneDrive file. Now, what I'm doing is generating the updated file, going to Power BI Desktop, clicking "Update" and after the data is updated, I re-publish the report to Power BI Service.
Could someone please help me?
Best regards,
Guilherme Vecchi
Solved! Go to Solution.
Hi @Anonymous ,
Please use Web connector rather than Excel in Power BI desktop. If you are using Onedrive for personal, please refer to this method. If you are using Onedrive for business, please refer to this article.
Best regards,
Yuliana Gu
Hi @Anonymous ,
Please use Web connector rather than Excel in Power BI desktop. If you are using Onedrive for personal, please refer to this method. If you are using Onedrive for business, please refer to this article.
Best regards,
Yuliana Gu
Thanks.
I've tested it out but for now, I tested only importing the OneDrive file. Works just like a local Excel file.
I still have to test how it works when I publish the report to Power BI Service. Hopefully it'll update the report based on the OneDrive file automatically.
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.