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.
I have created some reports in Power BI Desktop (that connect to a MYSQL database in the cloud) and published them to the Power BI Service.
The refresh routine on the Desktop application works perfectly but not so with the Power BI service.
Reading the Microsoft notes, it says that no gateway is required for an online data source, but when I try and refresh whilst using the service, each refresh attempt is being rejected saying that no gateway exists.
I am finding it very confusing and was wondering if anyone can help.
Cheers
Rollo
Hi @rollo,
What "Microsoft notes" are you reading where it states that? There's a few cases (DirectQuery, etc.) where a gateway is unncessesary, but for the most part it's needed. I've always needed one for any SQL Server import reports.
Hi @rollo,
Thanks for your sharing information.
Regards,
Yuliana Gu
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 |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |