Data refresh problem.

[Anonymous]

I have a pbix file that was refreshing normally sur desktop designer, but fails with the following error when online, whether manual or schedueled refresh. I've gone through every query in the file and there are no errors - all queries will refresh preview just fine, which is usually where I can find a sneaky error hiding.

Un problème s'est produit

Ce jeu de données inclut une source de données dynamique. Dans la mesure où les sources de données dynamiques ne sont pas actualisées dans le service Power BI, ce jeu de données ne sera pas actualisé. En savoir plus : https://aka.ms/dynamic-data-sources.

Réessayez plus tard ou contactez le support. Si vous contactez le support, fournissez ces informations.

• URI du clusterWABI-WEST-EUROPE-redirect.analysis.windows.net
• ID d'activité46bd2a53-88ff-478e-820b-f099af9aaeab
• ID de demande1ccbef1a-00c9-c4f6-37c2-dd0849473c25
• Heure2020-10-15 13:25:21Z

[Anonymous]

Thank you for your explanations.

I've fixed my problem.

[Anonymous]

Hi @Anonymous ,

Please kindly refer to, which describes how to set a secheduled refresh on a dynamic data source in Power BI:

https://medium.com/datadriveninvestor/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-bi-409ccec7337b#:~:text=Power%20BI%20datasets%20that%20use,parameters%20can%20also%20be%20refreshed.

Best Regards,

Stephen Tao

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

[Anonymous · Accepted solution]

mething went wrong

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more:

Please try again later or contact support. If you contact support, please provide these details.

• Cluster URIWABI-WEST-EUROPE-redirect.analysis.windows.net
• Activity ID46bd2a53-88ff-478e-820b-f099af9aaeab
• Request ID136be5fc-8c45-87c9-80db-108a59ba8710
• Time2020-10-15 15:07:35Z

Get helpCopy

[GilbertQ]

Hi there

As the error indicates you have got a data source where it is dynamically created.

To resolve this if you go into Power Query and click on Data Sources, it will say Hand Authored data source. You will then need to fix your table where this occurs.