Forum Discussion
Impactful IndividualStruggling with Gateway connections
I have an excel model imported to PBI Service. The creditials in my perosnal gateway I am stuck with are no longer valid as Sharepoint new syncing has changed all the folder paths. There seems no way to editt he credentials of this workbook.
i therefore installed the one premise gateway and added the file locations. I am getting this error message
Any thoughts appreciated
5 Replies
v-qiuyu-msftCommunity Support
Hi masplin,
In your scenario, it seems that the dataset connect to the SharePoint Folders, right?
If it's SharePoint online folder, you are not able to add this data source under data gateway, as data gateway doesn't support OAuth2 authentication now. Only personal gateway is available for this kind of data source. If that is a case, you need to import the Excel data model again, as the source path changed.
Best Regards,
Qiuyun Yu
masplinAh ok. So yes i have a single sql connection and then a bunch of excel files stored on OneDrive for Busoness. Am I right that the issue with the personal gateway is it records the path of the source files when you first upload, and these can never be changed. So if you change the path you have to reupload the workbook and completely rebuild you reports?
I was hoping the gateway would allow me some flexibilty over where the files are stored. Can I store them on Dropbox?
Really finding it extremly difficult to get Power BI set up and stable and not constantly breaking for some reason
Mike
- masplinMy SharePoint files are also stored on my c drive does this still make them online? The path on my gateway is c\users\mike\company name one drive etc. Why is this any differnet to a file store on the harddrive only?
Seems nuts that a Microsoft product doesn't work with a Microsoft product!!!!