The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
No matter the source / Excel or Blank Query I cannot get past the connection settings.
Exhausted forums and youtube on subject.
Thank you,
SMG
Solved! Go to Solution.
hi @spencer_II
Based on my research, your File path or URL is wrong.
it should like this format:
C:\Users\linli\Desktop\xxx\xxxx\xxxx\New Microsoft Excel Worksheet.xlsx
Not your path C:\Work\Analysis\Pwr BI Monthly
By the way, for local file, you need to add a new datasource in manage gateway like below:
And when you add this datasource, please don't enable Skip Test Connnection that make sure you could have a test this datasource.
https://radacad.com/the-power-bi-gateway-all-you-need-to-know
Regards,
Lin
hi @spencer_II
Based on my research, your File path or URL is wrong.
it should like this format:
C:\Users\linli\Desktop\xxx\xxxx\xxxx\New Microsoft Excel Worksheet.xlsx
Not your path C:\Work\Analysis\Pwr BI Monthly
By the way, for local file, you need to add a new datasource in manage gateway like below:
And when you add this datasource, please don't enable Skip Test Connnection that make sure you could have a test this datasource.
https://radacad.com/the-power-bi-gateway-all-you-need-to-know
Regards,
Lin
I don’t think you can set it to a local file.
It either has to be a network location or a (Sharepoint) URL.
Next to that you also should be a user of the data gateway entry for this location.
Thank you... so if I saved the file containing the Power Query to OneDrive?
Appreciate the assistance.
Spencer🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
36 | |
33 | |
23 | |
14 |