Power BI Dataset Scheduled Refresh not pulling in new data but succeeds

[rprice124]

Hello all,

I'm in need of some expert help, i have a power bi dataset thats configured to an API Cloud Datasource, i tried scheduling a refesh of the datasoure in the Power BI Service app and the schedules seem to have successed with no errors and the last date updates etc.  However there is no new data pulling into the report thats connected to this datasource?  Not sure if i'm missing a step or have something configured incorrectly but any help or suggestions would be greatly appreciated.  

[Anonymous]

Hi @rprice124 

As far as I’m concerned, if you don’t open the gateway option for this dataset, you should also go to the “Date source credential” to make sure each credential for the data sources is correctly entered.

What’s more, if the "Gateway connection" didn’t mention that you don’t need a gateway. I think you should also check if all the data source of your dataset are in the cloud, and avoid the condition of merging or appending on-premises and cloud data sources, which is explained in this document:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud

Finally, you can also check if the option has been turned on in your gateway setting:

Best Regards

Community Support Team _ Ailsa Tao

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

[rprice124]

Hi @Anonymous 

Thanks so much for your help and response, i checked the suggestions and it looks like gateway connection is saying "You don't need a gateway for this dataset becuase all of it's data sources are in the cloud".  I tested the data source credentials and it seems like it's letting me sign in, i then try to refresh the data set and it also seems like its refreshed and updates the refreshed date.  I then go back to the report and re-run and no new data is truely pulling into the report so i'm not sure if its actually refreshing? 

[rprice124]

Hi @nitishsh91 

Thanks so much for the help, i unchecked the Skip Test connection and it looks like it's authenticating, when i try to refresh the data it also seems to refresh and isnt throwing any errors but the data isnt truely refreshed?  Not what else i'm missing on this, see below for the query paramaters, this works in the desktop app its just after i publish to the web app that its not doing the data refresh

[nitishsh91]

Please can you share the code via which it connects to this web link and fetches the data, I doubt its able to get the data from there on online version

[rprice124]

Hi @nitishsh91 

Can i find this code in the online version or desktop version?  I checked online and didnt see anyting with the code, sorry new to this.

[nitishsh91]

No you will have to look for this in desktop version.

[rprice124]

Ok great thanks!  Here is the code, this is working in the desktop version, when i refresh it's pulling data correctly but not working after i publish

[nitishsh91]

Hi @rprice124 

Please can you uncheck that Skip Test connection adn try to Signin and see if its able to authenticate or not.

Also this API datasoure doesn't need any authentication to connect to and data is freely avaialble over the internet. Please also share the query parameters that you are passing to url and how are they being passed like a fixed url or dynamically creating the url to make a call.