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.
Hi Everyone,
I have a question about how to load data from Azure Analytics Service to the dataflow. As dataflow (Get data) does not have the option for Azure Analytics Service, so I pasted M queries (advanced editor) from desktop version in the blank query (dataflow) to load the data. I am asked to choose the On-promise data gateway.
My first question is if I need to choose a gateway.
Thank you so much.
Best, Qianru
Solved! Go to Solution.
Hi @qsong ,
Here is a document for your reference.
Both Connect live and Import options are supported. However, we recommended you use live connections because Import mode does have some limitations; most notably, server performance might be impacted during import. Also, if the model is to be refreshed in the Power BI service, the Allow access from Power BI setting applies only when choosing Connect live.
So you could check if you used import mode in desktop. Refresh only supports live connection and you don't need to configure a gateway.
Hi @qsong ,
Here is a document for your reference.
Both Connect live and Import options are supported. However, we recommended you use live connections because Import mode does have some limitations; most notably, server performance might be impacted during import. Also, if the model is to be refreshed in the Power BI service, the Allow access from Power BI setting applies only when choosing Connect live.
So you could check if you used import mode in desktop. Refresh only supports live connection and you don't need to configure a gateway.
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.