@powerquery

3 Topics

Folder in a Sharepoint LIST - How to access?
Hello, is there any way to access data from a folder that is inside of SharePoint list? After connecting to the list, it shows the folder as a Content Type - 'Folder' and there is no way to retrieve items from it. Is there maybe another method to access the library on SharePoint?
Solved
KSO_UC
1 year ago Place Report Server
1KViews
0likes
4Comments
PowerBI Server On Premise
Hi guys, Are we generate the list of dashboards that are showing in the PowerBI server and export them out in a list as a csv file or excel file. Instead of, opening every folder to know which dashboards are there. Thanks.
Solved
MrOnly_One
2 years ago Place Report Server
1.3KViews
0likes
3Comments
Power Query from cloud based server and on premise server and union both table together by function
I am in Power Query and I am given a custom function: to query from TWO different SQL servers - before they are different SQL servers but both on premise and right now I need change one server to Cloud version. After change, I was thrown this error message: DataSource.Error: Microsoft SQL: Could not find server 'AAASQL' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. Details: DataSourceKind=SQL DataSourcePath=BBBSQL;CSA Message=Could not find server 'AAASQL' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. ErrorCode=-2146232060 Number=7202 Class=11
Anonymous
3 years ago Place Report Server
814Views
0likes
2Comments