Helper IIIExcel Online Pivot Connected to Power BI Dataset Refresh/Connection Failure
I have an Excel file saved on Sharepoint online. This Excel file is connected to a PBI dataset and refreshes without issue in Excel desktop. I am not able to get the refresh to work when I open the Excel file in Sharepoint or in the Power BI Service (in the same workspace as the dataset).
Steps:
1. Connect Excel to PBI Dataset via Get Data > Power Platform > From Power BI (works in desktop)
2. Save to Sharepoint then upload to Power BI via Sharepoint
3. Try and adjust the pivot table when navigating to the workbook that is in the workspace:
Note, I have Admin to the tenant/workspace and am on GCC. This is functionality that worked previously.
Thank you
3 Comments
Hi AnAnalyst
Can you provide more error message about data refresh failed ? You mentioned that it was working fine before, did you make any changes during that time?
Best Regards,
Community Support Team _ Ailsa Tao
AnAnalystHi Anonymous
There are no other error messages. I just did some testing and it appears that if I upload the file from local (soon to be deprecated functionality) then I can adjust the pivot table in the tenant. When I use SharePoint or OneDrive it does not work.
So, it looks like something is going on with the authentication between Sharepoint and the PBI Tenant.
- AnAnalyst
Still trying to work through this issue. Please let me know if there is more info I can provide. There are no other error messages other than what I posted already.
