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.
Dear Support Team,
I have one power bi report where i have used data gateway to connect sql server and refresh the report, It is working fine.
Now for one of the report i used excel file as datasource and to refresh that datasource i am creating excel datasource in data gateway where i have provided the data source name then the sharepoint path of the excel file then selected windows and provided the user credentials which is used to connect the sharepoint. But when click on create button it is throwing below error:
"Unable to connect to the datasource. The input URL is invalid. Please provide a URL to the root of a SharePoint site, or to the service document or entity of its OData feed (with no query or fragment part). Please have this information handy if you choose to create a support ticket. ActivityId: 6c9f8474-a44c-4173-89b6-8785a62a7ba7 RequestId: 0f0ae298-8c76-450a-9c14-ae719f530c27 Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Jun 08 2022 20:55:11 GMT+0530 (India Standard Time) ActivityId: 6c9f8474-a44c-4173-89b6-8785a62a7ba7 RequestId: 0f0ae298-8c76-450a-9c14-ae719f530c27 Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Jun 08 2022 20:55:11 GMT+0530 (India Standard Time)"
Below is the image attached which i am trying to create datasource.
Kindly check and provide the solution. It is little urgent.
Thanks,
Vikash
If you are using SharePoint online, then you do not need a gateway
Not sure how you ingested your Excel file, but if you followed similar to the below (it says one drive, but works for sharepoint) then you shouldn't need a gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
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.