Forum Discussion
Error with dataflows using On-prem gateway
In case anyone else comes across this, turns out it was a proxy setting issue in our gateway's config files.
We followed the following documentation to update our config files to include our proxy configuration. (specifically the Microsoft.Mashup.Container.NetFX45.exe.config file), and it now works perfectly.
Hi PowerUP200 ,
1. The Local Data Gateway acts as a bridge that facilitates secure data transfer between local data sources and Azure services, including Power BI. Regarding the difference in behavior between Pro and PPU workspaces, it is worth noting that PPU (Power BI Premium per User) offers additional features and functionality compared to Pro. However, the use of local data gateways is not unique to Pro or PPU as the gateways are designed to work across different license tiers.
2. Consider the refresh duration of the data stream. the timeout thresholds for Power BI Pro data streams are two hours at the individual entity level and three hours at the entire data stream level. PPU is not subject to these timeout limits. For more details refer to the documentation: Understand and optimize dataflows refresh - Power BI | Microsoft Learn.
3. Check the gateway logs. Reviewing the gateway logs may provide insight into connectivity issues. Look for any errors or warnings that occurred during the dataflow refresh attempt.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Thank you for your response, very useful to know the difference between PPU and Pro for gateways.
But could I check, does the gateway work differently between semantic models and dataflows?
Hi PowerUP200 ,
The basic purpose of a gateway is to securely connect Power BI to a local data source in both scenarios, with the semantic model typically using a gateway for real-time data connectivity and DirectQuery operations, while data streams primarily use a gateway to bring in data from a local source. The performance impact of gateways can vary, with semantic models potentially facing real-time query performance considerations and data streams potentially encountering limitations related to data refresh times. More information on how gateways work can be found at the link: On-premises data gateway architecture | Microsoft Learn
The Power BI Gateway; All You Need to Know - RADACAD
Using an on-premises data gateway in Power Platform dataflows - Power Query | Microsoft LearnIf your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.