Hi, New Power BI user here. I'm trying to connect PBI and ClickDimensions. However I get the below error message when installing.I fill in the Data Center part (EU), but the it seems to skip the authentification-step where I fill in my login details: We couldn't install ClickDimensionsThere was an error when processing the data in the dataset.Please try again later or contact support. If you contact support, please provide these details.Message: The command has been canceled. Table: Visit.Activity ID: 62d9edfc-e5eb-482b-81dd-ed18660f2638Correlation ID: 5d010bac-24b4-3609-24f9-8c15011a980bRequest ID: 5a4d4b26-b624-b5fd-9f64-d9fb7f3ea241Status code: 400Time: Wed Sep 12 2018 13:25:05 GMT+0200 (Centraleuropæisk sommertid)Version: 13.0.6700.151Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net I hope someone can help with this. Will be greatly appreciated. :-)

HenrikW73,Please clear cache and stored password in your web browser, then sign in Power BI Service and import clickDimension content pack, check if you can fill in the credential. Alternatively, you can use in-private window of your web browser to sign in Power BI Service.There is a blog about how to connect to clickDimension content pack for your reference. If you still get errors, please download PBIX file based on your data center in this blog, and check if you can edit credential in the PBIX file.https://support.clickdimensions.com/hc/en-us/articles/115001162553-Power-BI-Content-PackRegards,Lydia

Hi Lydia, Following your advice and reading the blog post you linked to, I managed to get to the credentials login screen. However, even after submitting my login credentials, ClickDimensions still won't install. I now get the following error. Any idea for a next step? We couldn't install ClickDimensionsThere was an error when processing the data in the dataset.Please try again later or contact support. If you contact support, please provide these details.Message: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (An error has occurred.) Table: Visit.Activity ID: b83bc3c7-d0e1-40d8-8f57-6a45972a8402Correlation ID: ea86356b-0fcb-ca25-3ede-7f9a32761f9cRequest ID: 90cbb922-2533-ba89-c798-12692a366f38Status code: 400Time: Thu Sep 13 2018 09:44:05 GMT+0200 (Centraleuropæisk sommertid)Version: 13.0.6617.115Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net Kind regards, Henrik

HenrikW73,What is the result when you use PBIX file?Regards,Lydia

Hi Lydia, At first I didn't find any PBIX-file, but this was because I had only used and looked after the online version of Power BI until this point. I have now downloaded the desktop version, then the PBIX-file, and what happens when i open the file is that Power BI opens a canvas with a ClickDimensions graphic and some empty data reports. Was this what was supposed to happen? Disclaimer: When I initially posted this topic I had used my personal CRM login credentials for Power BI, when trying to Get Data. I later realized that I was supposed to use the account key and Power BI token from within ClickDimensions (embarrassed...). However, this changed nothing. Was still unable to install. Error text was this: We couldn't install ClickDimensions There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Message: The command has been canceled. Table: PostedForm. Activity ID: b83bc3c7-d0e1-40d8-8f57-6a45972a8402 Correlation ID: eb7858a5-198b-98a3-fe74-ae85a1a98f3d Request ID: eac48557-6e80-9406-a1ed-d6297643b928 Status code: 400 Time: Thu Sep 13 2018 11:53:34 GMT+0200 (Centraleuropæisk sommertid) Version: 13.0.6617.115 Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net Kind regards, Henrik

It simply opens a ClickDimensions canvas in Power BI Desktop with empty data. Is this what is supposed to happen? Nowhere was I prompted to fill in credentials of any kind. I have to admit, at first I thought I was supposed to use my personal login credentials, but after reading the blog post I realized, I needed to use the ClickDimensions account key and the Power token within CD. However, changing to those did not make any difference. I was still unable to install ClickDimensions in the cloud verson. Getting the below error message: We couldn't install ClickDimensions There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Message: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (An error has occurred.) Table: Visit. Activity ID: b83bc3c7-d0e1-40d8-8f57-6a45972a8402 Correlation ID: 9fc77567-e3a5-c26e-5dcf-06fe37e10f21 Request ID: b915dc6c-7327-7349-66e2-592bb9c5e061 Status code: 400 Time: Thu Sep 13 2018 13:13:06 GMT+0200 (Centraleuropæisk sommertid) Version: 13.0.6617.115 Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net Kind regards, Henrik

Clickdimensions connection issue | Microsoft Fabric Community

12 Replies

Anonymous
Not applicable
7 years ago
HenrikW73,

Please clear cache and stored password in your web browser, then sign in Power BI Service and import clickDimension content pack, check if you can fill in the credential. Alternatively, you can use in-private window of your web browser to sign in Power BI Service.

There is a blog about how to connect to clickDimension content pack for your reference. If you still get errors, please download PBIX file based on your data center in this blog, and check if you can edit credential in the PBIX file.

https://support.clickdimensions.com/hc/en-us/articles/115001162553-Power-BI-Content-Pack

Regards,
Lydia
- HenrikW73
  Regular Visitor
  7 years ago
  Hi Lydia,
  
  Following your advice and reading the blog post you linked to, I managed to get to the credentials login screen. However, even after submitting my login credentials, ClickDimensions still won't install. I now get the following error. Any idea for a next step?
  
  We couldn't install ClickDimensions
  There was an error when processing the data in the dataset.
  Please try again later or contact support. If you contact support, please provide these details.
  Message: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (An error has occurred.) Table: Visit.
  Activity ID: b83bc3c7-d0e1-40d8-8f57-6a45972a8402
  Correlation ID: ea86356b-0fcb-ca25-3ede-7f9a32761f9c
  Request ID: 90cbb922-2533-ba89-c798-12692a366f38
  Status code: 400
  Time: Thu Sep 13 2018 09:44:05 GMT+0200 (Centraleuropæisk sommertid)
  Version: 13.0.6617.115
  Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net
  
  Kind regards, Henrik
  - Anonymous
    Not applicable
    7 years ago
    HenrikW73,
    
    What is the result when you use PBIX file?
    
    Regards,
    Lydia

Forum Discussion

Clickdimensions connection issue

12 Replies

Related content

Data Gateway Connection Issue

Fabric Lakehouse connection issue

Lakehouse connection issue

Connection Timeout Issue

Connectivity Issue : Power BI to dynamics 365 (Dataverse)