Forum Discussion

Mikel_leaning's avatar
Mikel_leaning
Regular Visitor
3 years ago

Not possible to refresh from the service

This is the message:

Data source error: Unable to refresh the model (id=7426891) because it references an unsupported data source.
Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Activity ID: 6f41f463-3c61-409b-ab75-0ec64ce1a7fe
Request ID: 8eba26ab-adfc-5dd2-efd3-4420386d1504
Time: 2022-10-06 15:38:54Z

 

Many thanks,

Mikel

Need Help

2 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Mikel_leaning ,

     

    Could you please check that your data source is allowed in the documentation below: Power BI data sources - Power BI | Microsoft Learn

    And could I ask you that what special options you did? For example the customize function?

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Mikel_leaning's avatar
      Mikel_leaning
      Regular Visitor
      3 years ago

      Thank you v-yinliw-msft 

       

      No, it is not on the allowed data source list.

       

      However this is whaat I did:

       

      But to refresh data from the Service I should do as follows:

       

      Power BI: Schedule data refresh with on-premises data gateways

      Last updated: March 21, 2022

      This article shows you how to set up on-premises data gateways for your Power BI connection with iAuditor.

      Before you begin

      Why set up on-premises gateways for my Power BI?

      Currently, our iAuditor connector for Power BI Desktop is a custom connector, meaning data refresh can only be performed manually. Setting up on-premises gateways allows you to schedule data refresh for your Power BI connections, giving you the confidence that your iAuditor data will always be up-to-date when you use Power BI.

      You'll need

      1. Install an on-premises data gateway

      If your organization uses Power BI extensively, you may want to check with your IT team to see if an on-premises data gateway is already installed. If that's the case, skip to section "2. Connect iAuditor to your Power BI".

      If you need to install an on-premises data gateway, you can install it in either personal or standard mode:

      If you're unsure of which mode you should install, we recommend checking with your IT team.

      2. Connect iAuditor to your Power BI

      1. Download the latest version of the "iAuditorSigned.pqx" file.
      2. On the same device as your on-premises data gateway, navigate to the "Power BI Desktop" folder in your "Documents" directory. If the folder doesn't exist, create a new folder and name it "Power BI Desktop".
      3. Navigate to the "Custom Connectors" folder in your "Power BI Desktop" folder. If the folder doesn't exist, create a new folder and name it "Custom Connectors".
      4. Copy and paste the downloaded "iAuditorSigned.pqx" file into the "Custom Connectors" folder.
      5. Open Registry Editor on your computer and trust iAuditor as a third-party connector. You may require administrator access or contact your administrator to trust the connector. Enter the following value as the "TrustedCertificateThumbprints" when required:
        89F5E98CC7432AFA23D784DFE496A67D435767B5
      6. If you want to use Power BI Desktop with your iAuditor data as well, you can follow our Power BI Desktop instructions.

      3. Confirm custom connectors are enabled

      As the iAuditor connector for Power BI is a custom connector, you'll need to confirm that custom connectors are enabled for your on-premises data gateway.

      If you can't find "iAuditor by SafetyCulture" in the dropdown menu when selecting connectors, return to section "2. Connect iAuditor to your Power BI" and repeat each step carefully. The iAuditor connector must be in the correct folder and be trusted as a third-party connector in the "Registry Editor".

      4. Configure scheduled refresh for your Power BI

      Now that iAuditor is available for your Power BI, you can configure scheduled refresh with your on-premises data gateway.

      During setup, when you're adding iAuditor as the data source, please make sure the "Data Source Name" matches the "orgName" you provided when connecting iAuditor to Power BI. You can find the "orgName" under "Data Source Information".

       

      ------------------------

      I think that I have done everything correctly. Actually I can load the iAuditro data in my PBI Desktop.

       

      However I do not understand the last step:

       

      During setup, when you're adding iAuditor as the data source, please make sure the "Data Source Name" matches the "orgName" you provided when connecting iAuditor to Power BI. You can find the "orgName" under "Data Source Information".

       

      No Idea of this,  and I do not know if this has something to do with the problem.

       

      On the other hand this is the message I receive from the PBI server:

       

      Thank you very much!

      Mikel