Forum Discussion
Community ChampionDataflow Accessing a Sharepoint Folder with an xlsx
Hi DebbieE,
I'd like to suggest you use an excel connector with an excel URL to get data on dataflow.
https://testsite.sharepoint.com/sites/ExampleTeamsFoldername/Shared%20Documents/General/test.xlsx
Reference link:
Use OneDrive for Business links in Power BI Desktop
Regards,Xiaoxin Sheng
I also got around it by doing it in Desktop.
Then in Service creating a blank query and pasting the M Code into this query. Then it worked
Hi DebbieE,
I'd like to suggest you use an excel connector with an excel URL to get data on dataflow.
https://testsite.sharepoint.com/sites/ExampleTeamsFoldername/Shared%20Documents/General/test.xlsx
Reference link:
Use OneDrive for Business links in Power BI Desktop
Regards,
Xiaoxin Sheng
Community ChampionI also got around it by doing it in Desktop.
Then in Service creating a blank query and pasting the M Code into this query. Then it worked
QuentinHelper IV
Hello Debbie E,
I think i'm having the same issue of remote server returning an error.
I was already pasting the advanced editor in my dataflow advanced editor and over there it works i can see and transform the data in the Query of the dataFlow, then when i close de dataflow and set the refresh, the refresh last something like 40min and fail for this message: remote server returning error