Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ananya
New Member

Data Privacy in Power BI Service

If we choose the import option in a Power BI report, the data file will be saved in the Power BI service.
So, what other options do we have if we need Power BI to be on the Google Cloud Platform rather than Azure?

1 ACCEPTED SOLUTION
hackcrr
Solution Sage
Solution Sage

Hi, @ananya 

If you need to integrate Power BI with data stored on Google Cloud Platform (GCP) instead of Azure, there are several options you can consider. Each option depends on your specific data privacy and integration requirements. Here are the main approaches you can take:
1. Query Google BigQuery directly
Google BigQuery is a fully hosted data warehouse on GCP that supports direct querying from Power BI. This allows you to keep your data in the GCP while using Power BI for visualization and analysis.
2. Dataflows in Power BI
Power BI Dataflows can connect to a variety of cloud data sources, including Google Cloud Storage and Google BigQuery.This allows you to preprocess and store data in the Power BI service without having to import it directly.
3. If Power BI does not directly support data sources on GCP, you can create custom connectors using Power Query and the M language. An abbreviated procedure for creating a custom connector is included below:
Develop a custom connector using the Power Query SDK.
Use the Power BI REST API or another API endpoint to access your data.
Deploy the custom connector and configure the data source in Power BI Desktop.
4. Exporting Data to Azure Synapse or SQL Database
If you prefer to use the full feature set of Power BI through import mode, consider exporting your data from GCP to an Azure-based data service on a regular basis.
5. Power BI Embedded
For better control of data privacy and embedded analytics, consider using Power BI Embedded in conjunction with your own data storage solution.
6. Use Third-Party Integration Tools
Several third-party tools can facilitate data integration between GCP and Power BI. Tools such as Fivetran, Talend, or Informatica can automate data pipelines and ETL processes.

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
hackcrr
Solution Sage
Solution Sage

Hi, @ananya 

If you need to integrate Power BI with data stored on Google Cloud Platform (GCP) instead of Azure, there are several options you can consider. Each option depends on your specific data privacy and integration requirements. Here are the main approaches you can take:
1. Query Google BigQuery directly
Google BigQuery is a fully hosted data warehouse on GCP that supports direct querying from Power BI. This allows you to keep your data in the GCP while using Power BI for visualization and analysis.
2. Dataflows in Power BI
Power BI Dataflows can connect to a variety of cloud data sources, including Google Cloud Storage and Google BigQuery.This allows you to preprocess and store data in the Power BI service without having to import it directly.
3. If Power BI does not directly support data sources on GCP, you can create custom connectors using Power Query and the M language. An abbreviated procedure for creating a custom connector is included below:
Develop a custom connector using the Power Query SDK.
Use the Power BI REST API or another API endpoint to access your data.
Deploy the custom connector and configure the data source in Power BI Desktop.
4. Exporting Data to Azure Synapse or SQL Database
If you prefer to use the full feature set of Power BI through import mode, consider exporting your data from GCP to an Azure-based data service on a regular basis.
5. Power BI Embedded
For better control of data privacy and embedded analytics, consider using Power BI Embedded in conjunction with your own data storage solution.
6. Use Third-Party Integration Tools
Several third-party tools can facilitate data integration between GCP and Power BI. Tools such as Fivetran, Talend, or Informatica can automate data pipelines and ETL processes.

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors