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,
Solved! Go to Solution.
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).
@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!!
Is you primary question: