Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Gateway set up on Powerbi.com which is linked to an on-premises location. I have an Excel spreadsheet containing Data Models set as the data source.
I do not have an option in Powerbi.com to refresh the data source automatically. When I click 'Refresh Now' the refresh fails with the following message:
Data source error: | Unable to refresh the model (id=558618) because it references an unsupported data source. |
Cluster URI: | WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net |
Activity ID: | 2bed41fc-777c-4732-8052-1a0e28fa34e9 |
Request ID: | b181a0d3-3408-29d7-6920-30528ad488e4 |
Time: | 2019-04-03 15:33:07Z |
I can't find what the problem is and I don't want to go back to recreating everything manually.
Please help.
Hi @Anonymous
First please check the following:
You connect to an excel file on premise with Power BI Service,
the data in excel file is just simple data or from another data source?
If it is from another data source, when adding data source under the gateway, you should select this data source type instead of excel.
If it is simple data by entering data in excel, please share the setting where you add data source under gateway.
Best Regards
Maggie
Hello Maggie,
I have an analysis Excel spreadsheet which uses three data connections, one Excel worksheet and two nessus files. I pull these three data sources into the analysis spreadsheet.
I have added all of the data sources, including the analysis spreadsheet to the gateway as data sources. I still get the message:
Data source error: | Unable to refresh the model (id=558618) because it references an unsupported data source. |
Cluster URI: | WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net |
Activity ID: | cc3c85eb-ae66-45a9-9d93-d05bbd234b95 |
Request ID: | d86c2350-21ce-dc61-b3e2-785750bd2b5a |
Time: | 2019-04-04 07:50:04Z |
Thanks,
Infosec
Hi @Anonymous
Please read List of available data source types under gateway for refresh.
It seems it doesn't support nessus files.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.