User Profile

Alwyn1991

Frequent Visitor

Joined 7 years ago

12 Posts1 LikeLikes received

View All Badges

User Widgets

Contributions

Re: Sharepoint Folder
when you go on home on your sharepoint site you want to use that URL rather than the url when you can see the list for example https://my.sharepoint.com/sites/home/personal/list you actually want https://my.sharepoint.com/sites/home if that makes sense
4 years ago Place Desktop
53KViews
0likes
0Comments
Re: Sharepoint Folder
hey, are you trying to connet to the site or the full URL? might sound daft but if you connect to just the site and not the full url you should be able to navigate to the list Cheers Al
4 years ago Place Desktop
53KViews
0likes
2Comments
Re: Sharepoint Folder
Hey Neil, it does cache the first time logon unless within Transform Data/Power Query editor you use Refresh preview within the query you want to refresh
6 years ago Place Desktop
84KViews
0likes
0Comments
Re: Sharepoint Folder
Hey Ryan Anonymous , If its not showing on the sharepoint folder connection have you tried refreshing the preview to see if it appears then? i must admit it's not a particular issue that has arised for myself as of yet! alternatively you can use the web data connector? find the URL for the file and use the web connector. Please ignore the actual text in the image as it was only dummy data. If you use the fulla dress for the file in question once configured you will see in data source settings it will change itself to be a Sharepoint connection rather than a web connection or at least thats what has happened with myself in the past. Thanks Al
6 years ago Place Desktop
84KViews
0likes
2Comments
Re: Sharepoint Folder
Are you using a file specific URL for the data connector or using the sharepoint site URL i tend to use the latter and navigate to the file, the only other thing i can think of is if they are 2 different files? i.e. xlsx & xls normally sharepoint folder data connector seems to remove the idea of foldesrs within the document library and i just have huge list of files to select from
6 years ago Place Desktop
84KViews
0likes
0Comments
Re: Change Date format in Query Editor
LillyD have you tried in Query editor to replace the values i.e replace AM with blank the next step replace PM with blank then next step change the type?
6 years ago Place Desktop
12KViews
0likes
0Comments
Re: Incorrect Sub Totals in Matrix
Anonymous have you got a sample of the data you could perhaps share?
6 years ago Place Desktop
713Views
0likes
0Comments
Re: Import Data from an Excel sheet in SharePoint
you may well be aware of the soultion now, if you use Get Data and use sharepoint folder use the sharepoint site name and when in transform data navigate to the file you want this also helps when uploading the report the credentials login for scheduled refresh also
6 years ago Place Desktop
89KViews
1like
0Comments
Re: Sharepoint Folder
you may well be aware of the soultion now, if you use Get Data and use sharepoint folder use the sharepoint site name and when in transform data navigate to the file you want
6 years ago Place Desktop
85KViews
0likes
2Comments
Re: Power BI service scheduled Refresh is failing and not loading reports
Anonymous if you dont mind me asking in the dataset settings is there an error in your data source credentials?
7 years ago Place Service
1.6KViews
0likes
0Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.