Forum Discussion
undefined
Hi. It depends on you. You can create reports online with the datasets created from lakehouses or warehouses. However, you should consider that Power BI Desktop has way more features for making the users experience more friendly.
About refreshing data it's not about dataflows or other tool that you won't need a gateway, it depends on the source. If the source is on premise it doesn't matter if it's fabric or data factory or dataflows, you will need a gateway.
I hope that helps,
Power Bi Desktop can connect to data directly from your laptop. The Gateway is a tool used by PowerBi Service or Fabric in order to connect with Data that is usually onpremise.
So, let's say you have developed a report with Power Bi Desktop connected to a SQL Server. You publish the report to a workspace. Then, PowerBi Service or Fabric will need a Gateway in order to talk with the SQL Server on premise.
The gateway will be required in order to let any cloud services Fabric dataflow, power bi dataflow, power bi dataset, power bi datamart, data factory, etc. to connect with on premise data or some defined sources that even cloud will require gateway like MySQL.
If you have a SQL Server at a cloud service in azure like a Azure SQL Database, you don't need a gateway. However, if you have a sql server on a local environment or a VM, then you should install a gateway to let the powerbi or fabric cloud service talk with the data.
I hope that make sense
if i am using powerbi platform for power bi desktop the gateway id needed?second i have connected my sql server to build a data warehouse and if i use from there using a data flow then also gateway needed?just get confuding about ms fabric use
Power Bi Desktop can connect to data directly from your laptop. The Gateway is a tool used by PowerBi Service or Fabric in order to connect with Data that is usually onpremise.
So, let's say you have developed a report with Power Bi Desktop connected to a SQL Server. You publish the report to a workspace. Then, PowerBi Service or Fabric will need a Gateway in order to talk with the SQL Server on premise.
The gateway will be required in order to let any cloud services Fabric dataflow, power bi dataflow, power bi dataset, power bi datamart, data factory, etc. to connect with on premise data or some defined sources that even cloud will require gateway like MySQL.
If you have a SQL Server at a cloud service in azure like a Azure SQL Database, you don't need a gateway. However, if you have a sql server on a local environment or a VM, then you should install a gateway to let the powerbi or fabric cloud service talk with the data.
I hope that make sense