Power Apps to Dremio - How do I get data from the gateway?

[rc_stem]

I've set up a gateway between Dremio and the Power Apps Power BI. I'm confused on how to get the data from Dremio through the gateway. Previously, I had a connection between Dremio and the Power BI desktop and I would then publish the dashboard to Power Apps Power BI. I'm just trying to automate the process so I can just refresh the data weekly.

Thanks.

[Anonymous]

Hi @rc_stem ,

For Power BI refresh, if you choose import connection mode, when you create a data source in Power BI Service for the data gateway, you can configure a schedule time to refresh the data.

For more details, you can read related document: Configure scheduled refresh - Power BI | Microsoft Docs

For the data transform between gateway and data source, you can  read this article: On-premises data gateway architecture | Microsoft Docs

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rc_stem]

So the gateway has been established, I've tested the connection and it works. How do I get the data from that gateway? All I see are directions tell you how to create a gateway connection and then how to refresh the data. But there seems to be a middle step missing... 

[Anonymous · Accepted solution]

Hi @rc_stem ,

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps.

For more details, you can read related document: On-premises data gateway - Power BI | Microsoft Docs

If you want to get the data from transfer between on-premises and service, please try to use Fiddler 

For more details, you can read related document: Introduction of Fiddler

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.