Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
We have setup a gateway which has successfully connected to AWS as a datasource. It doesn't provide the option of import or direct query in Power BI Service.
This data can be viewed in the preview on the Power BI service as part of a dataflow.
However, it doesn't appear to be possible to build a dataset or report using this dataflow inside Power BI service. What is the best way to connect PBI to AWS?
I can't connect to redshift inside Power BI desktop on my laptop. I can connect to the dataflow but this appears to be using import rather than direct query which defeats the purpose of having AWS?
HI @ShaunBuchan,
You can refer to the following document to use power bi desktop to design reports based on dataflow tables:
Creating and using dataflows in Power BI
Regards,
Xiaoxin Sheng
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!