- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have to create a new data source to then connect to the azure db, instead of recycling the current connection.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I did so 🙂

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
12-20-2023 07:02 AM | |||
03-06-2024 04:41 PM | |||
03-21-2024 02:45 AM | |||
01-09-2023 10:23 PM | |||
04-15-2024 09:40 PM |
User | Count |
---|---|
10 | |
4 | |
4 | |
2 |
User | Count |
---|---|
9 | |
6 | |
5 | |
4 | |
4 |