Forum Discussion
Not possible to refresh from the service
Community SupportHi 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.
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, 2022This 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
- iAuditor Premium Plan
- Power BI Pro or Premium plan
- Hardware and software that support on-premises data gateways
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:
- Personal mode is suitable if you're setting up the gateway just for yourself.
- Standard mode is suitable if the gateway will be used across your organization. However, additional requirements may need to be met for this 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
- Download the latest version of the "iAuditorSigned.pqx" file.
- 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".
- 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".
- Copy and paste the downloaded "iAuditorSigned.pqx" file into the "Custom Connectors" folder.
- 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
- 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