Issue with power pivot import using a Tabular datasource

[chris30119]

Hello! I am trying to import a Power Pivot database with a Tabular data source into Power BI service via PBI desktop and set up data refresh via the on-premise data gateway.

I am able to import and refresh the dataset in PBI desktop.

When I publish the dataset from PBI desktop to PBI service, I get the report and the dataset in PBI service, but I am not able to refresh using an on-premises data gateway data source configured to the original Tabular database (SSAS 2012).

Error message:

You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.

Activity ID1c69121f-26cf-e175-f176-a05112df6f33

Request IDb6acf7b8-7382-9d69-e431-f93d584c4346

Correlation ID2c91b5f8-682d-f7e2-db64-1aeb9185b6ff

TimeFri Aug 11 2017 15:26:07 GMT-0700 (Pacific Daylight Time)

Version13.0.2080.159

Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net

The on-premises data gateway data source for the Tabular database does work for another PBI dataset which directly queries the Tabular database. I use the user id of the SSAS (Tabular) server administrator in the data source, which is also the same user id as the user logged in to Power BI service.

I am also able to import and refresh a Power Pivot database to PBI service that uses only a SQL Server (2012) database as a data source.

What should I try next?

Thanks!

[v-qiuyu-msft]

Hi @chris30119,

Based on my description, the dataset has two data sources, one is SQL Server database, the other is SSAS tabular, right?

To configure the dataset use data gateway, you need to create both SQL server and SSAS data sources under data gateway. Please go to Manage Gateways, create those two data sources use the same connection information (server name, database name) as in Power BI desktop. Then back to the Dataset settings, the data gateway should be available.

Best Regards,
QiuyunYu