Hello,
I am building an excel report for someone else which will be live in their SharePoint and will extract information from other files also located within their SharePoint.
So i want to create the file with parameters to make it easy for the end user to change connection and update with their SharePoint URL, I have watched numerous you tube videos and there are several videos covering parameters but i can't see any that specifically cover a SharePoint initial connection.
In my excel file I have a one line table which i have loaded into power query and made a text parameter called "ParConn" the text within the parameter = "https://xxxxxx.sharepoint.com/"
I am trying to use the new parameter within a query to connect to SharePoint and eventually I will build up the code to retrieve files from SharePoint but at the very first hurdle connection to SharePoint i get an error, I have used the following M code:
let
Source = SharePoint.Files(ParConn, [ApiVersion = 15])
in
Source
But when i try to load the query i keep on getting this error:
Formula.Firewall: Query 'Connect' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Can anyone help with this please as it's melting my brain!
I am building an excel report for someone else which will be live in their SharePoint and will extract information from other files also located within their SharePoint.
So i want to create the file with parameters to make it easy for the end user to change connection and update with their SharePoint URL, I have watched numerous you tube videos and there are several videos covering parameters but i can't see any that specifically cover a SharePoint initial connection.
In my excel file I have a one line table which i have loaded into power query and made a text parameter called "ParConn" the text within the parameter = "https://xxxxxx.sharepoint.com/"
I am trying to use the new parameter within a query to connect to SharePoint and eventually I will build up the code to retrieve files from SharePoint but at the very first hurdle connection to SharePoint i get an error, I have used the following M code:
let
Source = SharePoint.Files(ParConn, [ApiVersion = 15])
in
Source
But when i try to load the query i keep on getting this error:
Formula.Firewall: Query 'Connect' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Can anyone help with this please as it's melting my brain!
