Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone: I have a report created with Power BI Desktop that consumes an Excel file that is hosted on my PC.
When publishing to PowerBI service, I realize that the excel connection wants to install a Personal Gateway in my PC to connect to the excel file..., but I don't want to do that, because my client wants that excel file in the cloud (Sharepoint On-line / One Drive for business)...
So, I recently uploaded that excel file to a library on SharePoint On Line and shared with everyone in my organization. Then, I created a datasource in Power Bi Service that points to that file in Sharepoint...
Now I want to connect that new datasource to my report, so when a user updates that file in sharepoint, the report updated automatically..
Is that posible?
Thanks in advance,
Regards.
Solved! Go to Solution.
@andresgeb@alanhodgson This blog is a good walk through of how to use an Excel file as a source in SharePoint by @Mike_Carlo. Once you publish to the Service you can configure the refresh and this does not require a gateway.
Hi @andresgeb,
Is you primary question:
David
@andresgeb@alanhodgson This blog is a good walk through of how to use an Excel file as a source in SharePoint by @Mike_Carlo. Once you publish to the Service you can configure the refresh and this does not require a gateway.
@Seth_C_Bauer You saved my life, that worked perfect!
After a few data tranformations on the query editor I finnally connected to the file in the cloud, and the refresh was good!.
Thanks a lot!!
Regards.
Hey @andresgeb,
I am currently running an Excel spreadsheet from my organizations OneDrive for business to a dataset in PBI Service, and the only way to refresh the data in the PBI Service (that I have found) is to refresh the Excel spreadsheet (manually, by opening and hitting "Refresh All"). If you do not have PBI set up for a scheduled refresh, then go to the dataset in PBI and refresh now.
Essentially, PBI Service has no way of communicating through Excel to your data source.
Thanks @alanhodgson for your reply!.
My Excel File don't have any external connections, there are only plain tables.
My problem is that in my recently published report , I cannot change the connection to the datasource that connects to that file but in the cloud... I want my report connected to the excel file in the cloud (without gateways to my PC).
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.