Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Connexion of database problem (web api)

Hello everybody, I'm kinda new with power BI and I am facing a problem. I use an API to collect some data. This one give me data that power Query get with :" Source = Web.Page(Web.Contents(..." Wh...
Data Protection
Interesting Links
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

On Power BI Service, you need to configure credentials for the dataset before it can be successfully refreshed.

For cloud data sources, you need to enter the credentials under Settings -> Data source credentials.

 

 

For local sources, you need to use the gateway to configure the credentials.

 

For more information, please refer to: 

Configure scheduled refresh 

What is an on-premises data gateway? 

Add or remove a gateway data source 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi v-kkf-msft ,
Thank you for your answer. Unfortunately, I didn't find (yet I hope) the solution to my problem.

I looked for in the links and explanation you gave, my incomprehension is due to the type of the dataset.
In fact, it is not on a cloud (the "data source credentials" is unavailable in settings) or on my computer (I tried the install a Gateway but It shows me a warning that say that the dataset must be on a computer always on).

In fact, I collect my data from denodo with (on Power BI Desktop (it works here), then published on Power BI Desktop) a URL of this format  : https://[...]?$format=json

Do you know how can I connect this kind of dataset on Power BI Service please ?

Thanks by advance,

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    I haven't tried connecting to the denodo API. But I have connected to Powr BI Rest API, and when connecting to the data source using the Web connector, I need to configure the data source credentials using the gateway.

    • First enable "Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster" in the gateway settings.
    • If your access token is included in the M code, then you need to Skip Test Connection when configuring.

    There are specific steps in this thread, please check if it applies to your situation.

    https://community.powerbi.com/t5/Service/Power-Bi-workspace-content-overview/td-p/2348069 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.