I have set up an on-premises data gateway on a server in our company. A datasource has been added in the gateway settings in Power BI with the information required to connect to our SQL database. The data refresh in Power BI works perfectly for reports where the SQL server is the only source, or where a OneDrive file is the only source. However, as soon as I link to a OneDrive Excel spreadsheet and SQL server in the same dataset, the refresh no longer works. When I look at the settings for the dataset, I am told I need to install a personal gateway and I can no longer select the gateway I have already set up. Adding the link to the file in the gateway settings doesn't help either. If these two sources work fine independently, why don't they work in the same dataset?
3 Comments
- I just came to post the exact same problem. I can refresh them locally on the Desktop version, but published together, and I get the same behavior described above. This happens also with SSAS cubes/models and OneDrive sources as well.
- I have the same issue: Failed to load data sources. Please try again later. Please try again later or contact support. If you contact support, please provide these details. Activity IDb67106aa-7fec-4268-8e1e-70f807caa0d1 Request IDda92f9f9-989c-99d0-443d-4175daaa4877 Correlation ID0f1e7499-bb52-a1c2-5685-2806847c10fe Status code400 TimeTue Jan 03 2017 11:59:19 GMT+0100 (Central European Standard Time) Version13.0.1700.872 Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net
- Status added:New
