The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
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 |
---|---|
55 | |
42 | |
24 | |
23 | |
14 |