Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everybody,
I would like to update my queries from Dynamics365 automatically without using a local gateway.
I've already done another report (queries from DYN365) but I don't know where the difference is. The Scheduled Update option is not available.
Thank you for your support!
Solved! Go to Solution.
Hi @Anonymous ,
You can change the setting in the Power Query to NOT refresh the Excel file. Just UNCHECK it.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @Anonymous ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards,
Icey
Hi @Anonymous ,
If you are cloud to cloud then you don't need to have a gateway. But, if your dataset is internal, you will have to have a gateway to automatically refresh the data.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @Anonymous ,
You can change the setting in the Power Query to NOT refresh the Excel file. Just UNCHECK it.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hallo @collinq,
it works now.
I simply inserted the static data in an internal Power Bi table and deleted the Excel query. Now all queries only come directly from DY365.
Many thanks for the help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |