Forum Discussion
Dataflow Can't Connect to SharePoint Excel File
Hi lg1551 ,
This issue has been submitted internally. Internal ICM ID: 341717747 . Please be patient to wait for fixing. If there is any news, I will update it here.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you create a new Dataflow pointing to the same file in Sharepoint?
I'm unable to do that as well.
We have an existing PBIX desktop file which points to the SharePoint excel file. I'm wanting to convert all of the SharePoint sources to a dataflow with autorefresh to save some time when refreshing the PBIX. But when I point the DataFlow to the SharePoint excel file I get the credentials error. It makes no sense to me. The same credentials are used in the service, as are in the desktop PBIX as are used in the SharePoint. It's my same organizational account. I will check with the admin and see if there is some permissions setting that needs adjusting in the service.
I don't think going through Dataflows is the best approach, Sharepoint is already an online service and has good connection to Power BI service. Maybe you have anthore reason to build on top of Dataflows. Anyways, I think the way you connected or trying to connect to Sharepoint is defaulting in here. Can you give more details on how did you build your report on top of sharepoint?
The reason for the dataflow is because they use a ton of SharePoint sources, excel files, lists, etc that take a long time to refresh in desktop. If they are fed to the dataflows which auto refresh nightly then the desktop can grab the transformed data and load the visuals. I just finished a separate report and it went from a 10-12 minute refresh to a 2-3 minute refresh by moving the SharePoint sources into dataflows.