Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I an running a function to import data from Excel spreadsheets. It begins with something like
Excel.Workbook(Web.Contents(pathName))
with the pathName being passed as a parameter such as "https://spo.domain.com/sites/long_path_name/file_name.xlsx"
So far, so good. It's working fine in PowerBI desktop but when trying to use it in a Dataflow I get the error message of "One or More tables references a dynamic data source". Fair enough, I've modified the above to
Excel.Workbook(Web.Contents("https://spo.domain.com",[RelativePath="sites/long_path_name/file_name.xlsx"]))
The only problem is that using the latter doesn't allow me to authentificate using my normal credentials. For some reason, using
Excel.Workbook(Web.Contents("https://spo.domain.com/sites/long_path_name/file_name.xlsx"))
works fine, but using
Excel.Workbook(Web.Contents("https://spo.domain.com/",[RelativePath="sites/long_path_name/file_name.xlsx"]))
Does not work. What am I missing?
You are missing the part where they told you to never use a Web connector for Excel files on a Sharepoint. Use the "SharePoint Folders" conenctor instead.
That doesn't solve the problem.
It does, bceause now it is properly handling OAUTH authentication.