Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey folks,
This might be an obvious one, but...
Is it possible? Until now, I have only used an Enterprise Gateway to access on premises SQL data and I can't figure out what I am missing.
Edit: I should clarify, I can get the dataset to refresh just fine since its built on a a sharepoint excel file, but how can I get to the dataset via Power BI desktop which has more powerful report authoring and query editing options?
Thank you,
Jesse
Solved! Go to Solution.
I found a potential soloution here: chopping everything off the link after the file name, INCLUDING .xslx, allowed me to get a little futher using the file link via the Get Data/Web interface in Power BI desktop. But then it wont let me authenticate with my organizational account. bear in mind I am the global office 365 admin for my company. I feel closer... but help!
One thing that looked promising was punching in the web path of the Sharepoint file (in Power BI desktop, Get Data/Web), but that genrates the following error:
I found a potential soloution here: chopping everything off the link after the file name, INCLUDING .xslx, allowed me to get a little futher using the file link via the Get Data/Web interface in Power BI desktop. But then it wont let me authenticate with my organizational account. bear in mind I am the global office 365 admin for my company. I feel closer... but help!
Embarrased to admit I sorted it out, but getting the sharepoint file path link via excel, and deleteing everything >= the ? worked. For whatever reason the authetication error dissapeared this go around.
Shout out to Matt Allington for the helpful blog post I found in another thread.
Best,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.