cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
krajani
Helper V
Helper V

Cannot connect to tabular (SSAS 2016 development edition) from Service

Hi everyone,

 

I have developed a tabular cube using SSAS 2016 developer edition. I am getting the following message when I attempt to connect to this cube within the Service. Refresh history hasn't been helpful as such. The show/hide details option has nothing to offer.

 

 

ErrorErrorRefresh HistoryRefresh History

 

Thanks
Kaz

1 ACCEPTED SOLUTION

I was able to resolve this by specifying FQDN of the server, in data source in PBI Desktop as well as the gateway. 

 

So my connection string looks like this: servername.domainname.xxx\SSAS instance name. Earlier it was servername\ssas instance name, and this worked well except didn't allow me to perform refresh.

 

Thanks
Kaz

View solution in original post

4 REPLIES 4
v-huizhn-msft
Microsoft
Microsoft

Hi @krajani,

The error message shows the data source can not be accessed by Gateway. Did you add the SQL Server Analysis Server in the Gateway? If not you must add the Analysis service in the gateway by clicking Manage Gateway under Settings. If you have added it, please check if you can connect it successfully. And retype the credentials. More details, please review this article.

Best Regards,
Angelia

Hi Angelia, 

 

Thanks for replying. My gateways are in place, and what confuses me is that the published report has all visuals crossed out. However, if I go to the dataset that gets added when you select the AS Gateway from 'Get Data > Databases > SQL Server Analysis Services > SSAS Gateway > Cube Name', and then create a report, I can see the data! Not sure what's happening. 

 

Here are the entries from gateway log; I've replaced the name of instance & the actual user name with place holders, <instance_name> & pbiuser@company.com.au values respectively, to be precise.

 

c4276817-25ea-89fd-f3ab-5d18e72eb373 C7CB57CC [DM.GatewayCore] Db pool opening raw database connection to [MSOLAP.5: <pi>MSOLAP.5:provider=MSOLAP.5;data source=<instance_name>\devtabular;initial catalog="Human Resources";timeout=180;effectiveusername=pbiuser@company.com.au;sspropinitappname=PowerBI:[Windows] Encrypted Credential information omitted</pi>]
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.3966668Z DM.EnterpriseGateway 93c2323c-e5ab-47c5-b2f6-9a7005cd0d89 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGCC c4276817-25ea-89fd-f3ab-5d18e72eb373 0D27967A [DataMovement.PipeLine.GatewayDataAccess] Replace effective user name in adomd connection string from pbiuser@company.com.au to pbiuser@company.com.au.
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.4122669Z DM.EnterpriseGateway 2d0a124a-1cb2-49df-a94e-66d9fb42f696 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGCC c4276817-25ea-89fd-f3ab-5d18e72eb373 0D27967A [DataMovement.PipeLine.GatewayDataAccess] Replace effective user name in adomd connection string from pbiuser@company.com.au to pbiuser@company.com.au.
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.4122669Z DM.EnterpriseGateway 62ff7e03-7018-4950-8efa-9ea55d98789d 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGCC c4276817-25ea-89fd-f3ab-5d18e72eb373 0D27967A [DataMovement.PipeLine.GatewayDataAccess] Replace effective user name in adomd connection string from pbiuser@company.com.au to pbiuser@company.com.au.
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.4434671Z DM.EnterpriseGateway 5ba0cabc-abbc-430f-ad95-296906f1aeb7 aea9fcca-867f-44d0-9b67-782502686feb MGPP d253f3f7-611f-4571-aa66-acc176dbc5fe 7E7152BF [DM.Pipeline.Common] Pool cleaner connections removed: 0, count: 7, buckets: 1
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.7398690Z DM.EnterpriseGateway c726d159-9c07-4ddd-ab9c-cd08fa6a4f34 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.8022694Z DM.EnterpriseGateway 390c257d-98dc-48d6-be50-8a132a640118 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.8646698Z DM.EnterpriseGateway 8694dbba-e29b-40b3-81ad-b00f5be797d9 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.9270702Z DM.EnterpriseGateway fd80ab79-d8c2-47b5-bc1d-1512a0e16c6b 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:32.9738705Z DM.EnterpriseGateway 5a52b411-ae2f-415f-9481-88ebb7a57eaf 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:33.0372710Z DM.EnterpriseGateway ecdc7bde-95d5-42c8-8fa8-0ce2dccfbc82 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:33.0996714Z DM.EnterpriseGateway f38fbe1d-c518-4d40-a2e7-ec03d8beb59f 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:33.1464717Z DM.EnterpriseGateway 07fbc7ee-57c4-4c4c-88c2-091624262968 33bfe9e1-bed0-9ba9-e8ae-500fc473cdfa MGPP c4276817-25ea-89fd-f3ab-5d18e72eb373 A98CFF93 [DM.GatewayCore] Deserialized GetSchemaDataSetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:04:47.9041663Z DM.EnterpriseGateway 5ba0cabc-abbc-430f-ad95-296906f1aeb7 aea9fcca-867f-44d0-9b67-782502686feb MGPP d253f3f7-611f-4571-aa66-acc176dbc5fe 4D97BD4E [DM.Pipeline.Common] Pool cleaner connections removed: 5, count: 126, buckets: 38
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:02.4590596Z DM.EnterpriseGateway 5ba0cabc-abbc-430f-ad95-296906f1aeb7 aea9fcca-867f-44d0-9b67-782502686feb MGPP d253f3f7-611f-4571-aa66-acc176dbc5fe 7E7152BF [DM.Pipeline.Common] Pool cleaner connections removed: 0, count: 7, buckets: 1
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:17.9091592Z DM.EnterpriseGateway 5ba0cabc-abbc-430f-ad95-296906f1aeb7 aea9fcca-867f-44d0-9b67-782502686feb MGPP d253f3f7-611f-4571-aa66-acc176dbc5fe EDD95B1F [DM.Pipeline.Common] Pool cleaner connections removed: 0, count: 126, buckets: 38
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:32.4640525Z DM.EnterpriseGateway 5ba0cabc-abbc-430f-ad95-296906f1aeb7 aea9fcca-867f-44d0-9b67-782502686feb MGPP d253f3f7-611f-4571-aa66-acc176dbc5fe 7E7152BF [DM.Pipeline.Common] Pool cleaner connections removed: 0, count: 7, buckets: 1
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.5232657Z DM.EnterpriseGateway a41752fb-6b4e-4a93-a408-47ba11634a53 bf0f944c-6686-c0a7-bace-d371b78ebd15 MGPP 46991a44-a8a1-46d5-7997-7f5692a4dc18 1F9FF400 [DM.GatewayCore] Deserialized OleDbCreateRowsetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.5232657Z DM.EnterpriseGateway 730f53ee-3541-4bea-bd84-d4b565d02c4a bf0f944c-6686-c0a7-bace-d371b78ebd15 MGOM 46991a44-a8a1-46d5-7997-7f5692a4dc18 669527D0 [DM.GatewayCore] Optional command property c8b522be-5cf3-11ce-ade5-00aa0044773d:BOOKMARKS is not supported by MSOLAP.5
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.5232657Z DM.EnterpriseGateway b04effe2-2c94-4473-ae15-4d8e198212ae 0c39f166-26e9-6316-bfb8-0903380d111c MGPP 46991a44-a8a1-46d5-7997-7f5692a4dc18 1F9FF400 [DM.GatewayCore] Deserialized OleDbCreateRowsetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.5232657Z DM.EnterpriseGateway c9ad3197-f935-4a12-898d-1caf895a086e 0c39f166-26e9-6316-bfb8-0903380d111c MGOM 46991a44-a8a1-46d5-7997-7f5692a4dc18 669527D0 [DM.GatewayCore] Optional command property c8b522be-5cf3-11ce-ade5-00aa0044773d:BOOKMARKS is not supported by MSOLAP.5
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.5700660Z DM.EnterpriseGateway 74dcf114-621c-49b6-83e9-cae5b01b8cd8 6dbe44c9-997c-bb02-6399-820dcd1448c9 MGPP 46991a44-a8a1-46d5-7997-7f5692a4dc18 1F9FF400 [DM.GatewayCore] Deserialized OleDbCreateRowsetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.5700660Z DM.EnterpriseGateway 0d9894c3-b3fb-4e34-9d2e-441b08c23902 6dbe44c9-997c-bb02-6399-820dcd1448c9 MGOM 46991a44-a8a1-46d5-7997-7f5692a4dc18 669527D0 [DM.GatewayCore] Optional command property c8b522be-5cf3-11ce-ade5-00aa0044773d:BOOKMARKS is not supported by MSOLAP.5
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.6792667Z DM.EnterpriseGateway 95ef0d88-d322-4da4-9bd7-103f2eae552f 86e3178d-8027-b8af-ffc1-7ac24b40cf8e MGPP 46991a44-a8a1-46d5-7997-7f5692a4dc18 1F9FF400 [DM.GatewayCore] Deserialized OleDbCreateRowsetRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:34.6792667Z DM.EnterpriseGateway 53cdcfdd-5c05-4457-bc0e-84123c834ccc 86e3178d-8027-b8af-ffc1-7ac24b40cf8e MGOM 46991a44-a8a1-46d5-7997-7f5692a4dc18 669527D0 [DM.GatewayCore] Optional command property c8b522be-5cf3-11ce-ade5-00aa0044773d:BOOKMARKS is not supported by MSOLAP.5
DM.EnterpriseGateway Information: 0 : 2017-06-27T03:05:47.9121519Z DM.EnterpriseGateway 5ba0cabc-abbc-430f-ad95-296906f1aeb7 aea9fcca-867f-44d0-9b67-782502686feb MGPP d253f3f7-611f-4571-aa66-acc176dbc5fe EDD95B1F [DM.Pipeline.Common] Pool cleaner connections removed: 0, count: 126, buckets: 38

 

Thanks
Kaz

I was able to resolve this by specifying FQDN of the server, in data source in PBI Desktop as well as the gateway. 

 

So my connection string looks like this: servername.domainname.xxx\SSAS instance name. Earlier it was servername\ssas instance name, and this worked well except didn't allow me to perform refresh.

 

Thanks
Kaz

View solution in original post

krajani
Helper V
Helper V

Quick update. I deleted the gateway and created it again. Now, I get the following message. In PBI Cloud, every visual in the report is crossed out.

 

Publishing messagePublishing message

 

Thanks
Kaz

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!