Unable to refresh a dataset of M Code for Gemini API call in Power BI Service

[Eshan9163]

I have written M code in advance editor of PBI Desktop to call Gemini API and build a table of single cell consisting the response of Gemini based on the given prompt. In PBI desktop, the response data obtained from API call is refreshed based on the applied filters by selecting manual refresh each time. However, I am unable to refresh it on the Power BI service. I am getting an error as "You have no personal gateways installed" even after installing an on-premise gateway.  The installed gateway reflects as active but still I am unable to refresh.

[ibarrau]

Hi. If that's your only source, ignore the message and go to Semantic model settings, open data source credentials and edit them. The gateway is showing that it is a cloud connection. You don't need a gateway (unless you are doing some python or R inside)

I hope that helps,

[Anonymous]

Hi @Eshan9163,

Thank you for reaching out to Microsoft Fabric Community Forum.

Based on the screenshot above, the gateway status is "Not configured correctly", indicating an incomplete connection setup.

The Web data source (Gemini API) is mapped to "Personal Cloud Connect". Since the Google Gemini API is a cloud service, an on-premises gateway is not required.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu

[Eshan9163]

Thank you for the suggestion.

I have deleted the on premises gateway connection and tried connecting through personal cloud connect but still I am getting error. I have set authentication method as anonymous and privacy level as public. Please refer the below given image

---

This is the full error message

Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.



Details: Web.Contents failed to get contents from 'https://generativelanguage.googleapis.com/v1/models/gemini-1.5-flash-8b:generateContent?key=AIzaSyBG...' (404): Not Found Please have this information handy if you choose to create a support ticket. Session Id: 141c063e-b01d-4211-baa3-667825d1b8e1 RequestId: 0cd16f24-1417-48d3-b036-411df2ee36a5 Cluster URI: https://api.powerbi.com Status code: 400 Time: Fri Feb 28 2025 15:48:39 GMT+0530 (India Standard Time)

[ibarrau]

Hi. If the API is your only source, if you only have tables from cloud sources, try not using the gateway at all. Open the Power Bi Service. Go to Semantic Model Settings and edit credentials:

I hope that helps

[Eshan9163]

Thank you for the response.

I am unable to select the datasource credentials option. Please check the below attached screenshot.

[Anonymous]

Hi @Eshan9163,

Check if you have the correct permissions:
Ensure you are an admin or owner of the dataset.
Locate to your dataset, click the three dots (⋮), and select Manage Permissions.
Verify your role to confirm you have the necessary access.

Regards,

Vinay Pabbu

[Eshan9163]

Hello,

Thanks for the response.

I have admin permissions. Is there any additional settings that I need to make as an admin in my premium per user account?

Thanks and regards,

Eshan Kumar

[Anonymous]

Hi @Eshan9163,

If the 'Data Source Credentials' option is disabled (grayed out) in Power BI Service, it usually means that Power BI does not recognize the API request as a valid data source or that your M code uses dynamic URLs, causing it to be classified as an 'unsupported cloud data source.'
If the option is editable, set the authentication method to OAuth or as required by the API.

Regards,

Vinay Pabbu

[Eshan9163]

Hello @Anonymous ,

I tried to set the authentication method as OAuth2 as shown in the below attached screenshot but still it's the same.

[Anonymous · Accepted solution]

Hi @Eshan9163,

I suggest reaching out to Microsoft Support by raising a ticket. Microsoft will analyze backend logs and provide a resolution.

Below is the link to create Microsoft support ticket:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket 

Regards,

Vinay Pabbu

[Anonymous]

Hi @Eshan9163,

As we haven't heard back from you, I hope you have raised a support ticket. At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.

Thank you for being part of the Microsoft Fabric Community.

Regards,

Vinay Pabbu