- 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
refresh not working for SQL Server + SharePoint Online blend
I have a report that blends together data from SQL Server and SharePoint (Online). The privacy level of both is 'Organization'. The SQL Server source uses a 'Windows' credential. The SharePoint source uses an 'Oranizational account' credential. When I attempt to refresh the report in the service, it fails, and I don't understand why (or how to resolve).
I have an on-premises gateway installed on a server. When I access the report's dataset's settings, under 'Gateway connection', the gateway says 'Not configured correctly' (under Status). When I expand the arrow icon under Actions for View Datasources, I can see both data sources in this dataset. My SQL Server source has a green arrow next to it, but its 'Maps to' field is empty. Even though I can select the corresponding data source, it doesn' stay (when I leave the page). My SharePoint source has a red x next to it, and a message that reads 'Add to gateway'. There is a yellow warning icon under this that says 'You have no personal gateways installed'. Everything on my gateway looks good, and connections are successful. For reference, I have the following unchecked: 'Allow user's cloud data sources to refresh through this gateway cluster...'.
How do I resolve this problem?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I believe your issue is the very last thing in your post.
"For reference, I have the following unchecked: 'Allow user's cloud data sources to refresh through this gateway cluster...'."
You need to turn this on so your gateway will let your cloud services refresh. You don't need to do any configuration, as it will simply pass through. You'll see it come up with an "Optional".
Once you configure that correctly, you'll be able to select your other source from the dropdown and click apply. It should then save that change.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @Anonymous,
For power bi reports who use the mixed Datasource(both online and on-premise), I'd like to suggest you turn on 'use gateway to handle cloudy data source' option to allow the gateway to manage whole datasets.
Notice: mixed dataset contains two types of datasources, if you only configure one datasource on your gateway, it not able to refresh due to configured data source not match with your report used.
Merge or append on-premises and cloud data sources
If turn on that option does not helps, please share more detailed information to help us clarify your scenario.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
If this post helps, please consider accept as solution to help other members find it more quickly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I believe your issue is the very last thing in your post.
"For reference, I have the following unchecked: 'Allow user's cloud data sources to refresh through this gateway cluster...'."
You need to turn this on so your gateway will let your cloud services refresh. You don't need to do any configuration, as it will simply pass through. You'll see it come up with an "Optional".
Once you configure that correctly, you'll be able to select your other source from the dropdown and click apply. It should then save that change.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-06-2024 04:41 PM | |||
09-18-2024 05:58 AM | |||
11-30-2023 10:05 AM | |||
12-13-2024 10:53 AM | |||
03-11-2024 08:22 AM |
User | Count |
---|---|
55 | |
52 | |
49 | |
13 | |
11 |