There are two ways to connect data to Power BI Desktop.
The user will open Power BI Desktop and connect to Data Ocean (Google BigQuery), where the Data Team ensures that data is reliably extracted, transformed, and made available from all requisite data sources. This enables users to seamlessly access and push the data as needed. Once the connection is established, the user can begin building reports and dashboards to derive insights and share them with stakeholders.
In this scenario, the user will not require intervention from the Data Team, as they have independently processed the data and made it readily available in Google Sheets.
For more information regarding to data architecture and Data Ocean, you can see here.
A custom theme has been created in Power BI with SOLVAY colors and font and is available in a JSON file below. You just need to click "View" → "Browse for themes" → Select the JSON file.
JSON with following parameters:
As part of our organization's commitment to maintaining data security, compliance, and effective management of business intelligence resources, it is essential to configure Power BI tenant settings. These settings ensure that our use of Power BI aligns with company policies and industry standards. By setting up and customizing these configurations, we can control access, optimize resource utilization, and safeguard sensitive data while enabling collaboration and reporting across teams.
This setup reflects our dedication to adhering to organizational guidelines and supporting a secure, productive data ecosystem.
| Power BI Tenant Settings | Configuration |
| Data Activator (preview) | Enabled for Tenant Admins |
| Users can create Fabric items | Disabled |
| Publish ‘Get Help’ Information | Enabled |
| Receive email notification service outages or incidents | Enabled for Tenant Admins |
| Allow users to try Microsoft Fabric paid Features | Enabled Tenant Admins |
| Show a custom message before publishing reports | Disabled |
| Create workspaces | Enabled |
| Use semantic models across workspaces | Enabled |
| Block users from reassigning personal workspace (My Workspace) | Enabled |
| Define workspace retention period | Enabled (30 days) |
| Allow users to apply sensitive labels and other settings related to Information Protection and Other settings. | Disabled |
| Apply sensitivity labels from data sources to their data in power BI | Disabled |
| Automatically apply sensitivity labels to downstream content | Disabled |
| Allow workspace admins to override automatically applied sensitivity labels | Disabled |
| Restrict content with protected labels from being shared via link with everyone in your organization | Disabled |
| Allow Azure AD guest users to access Microsoft Fabric | Enabled |
| Power BI Tenant Settings | Configuration |
| Show Azure AD guest users in lists of suggested people | Enabled |
| Publish to web | Disabled |
| Copy and paste visuals | Enabled |
| Export to .csv | Enabled |
| Export to Excel | Enabled |
| Download reports | Enabled for Tenant Admins and |
| Users can work with semantic models in Excel using a live connection | Power Bi Pro license users |
| Export reports as PowerPoint presentations or PDF documents | Enabled |
| Export reports as MHTML | Enabled |
| Export reports as Image files | Enabled |
| Export reports as Word documents | Enabled |
| Export reports as XML documents | Enabled |
| Print dashboards and reports | Enabled |
| Certification | Enabled |
| Users can set up email subscriptions | Enabled for Tenant Admins |
| Power BI Tenant Settings | Configuration |
| B2B guest users can set up and be subscribed to email subscriptions | Enabled |
| Users can send email subscriptions to external users | Disabled |
| Featured Content | Enabled |
| Allow connections to featured tables | Enabled |
| Enable Microsoft Teams integration | Enabled |
| Install Power BI App for Microsoft Teams Automatically | Enabled |
| Enable Power BI add-in for Power Point | Enabled |
| Allow DirectQuery connections to Power BI semantic models | Enabled |
| Guest users can work with shared semantic models in their own tenants | Disabled |
| Allow Shareable links to grant access to everyone in your organization | Disabled |
| Allow specific users to turn on external data sharing | Enabled for Tenant Admins |
| Make promoted content discoverable | Enabled |
| Make certified content discoverable | Enabled |
| Discover content | Enabled |
| Create template organizational apps | Disabled |
| Push apps to end users | Enabled for Tenant Admins |
| Power BI Tenant Settings | Configuration |
| Publish apps to the entire organizations | Enabled |
| Allow XMLS endpoints and analyze in Excel with on-premises semantic models | Enabled |
| Semantic Model Execute Queries REST API | Enabled |
| Use ArcGIS Maps for Power BI | Disabled |
| Use global search for Power BI | Enabled |
| Use Azure Maps Visual | Disabled |
| Map and filled map visual | Enabled |
| Integration with SharePoint and Microsoft Lists | Enabled |
| Dremio SSO | Disabled |
| Snowflake SSO | Enabled |
| Redshift SSO | Disabled |
| Google BigQuery SSO | Disabled |
| Oracle SSO | Disabled |
| Azure AD Single Sign-On (SSO) for Gateway | Disabled |
| Power Platform Solutions Integration (preview) | Disabled |
| Users can view Power BI files saved in OneDrive and SharePoint (preview) | Enabled |
| Power BI Tenant Settings | Configuration |
| Users can share links to Power BI files stored in OneDrive and SharePoint through Power BI Desktop | Enabled |
| Enable granular access control for all data connections | Disabled |
| Semantic Models can export data to OneLake (preview) | Disabled |
| Users can store semantic model tables in OneLake (preview) | Disabled |
| Semantic model owners can choose to automatically update semantic models from files imported from OneDrive or SharePoint | Enabled |
| Allow visuals created using Power BI SDK | Enabled |
| Add and use Certified visuals only (block uncertified) | Enabled |
| Allow downloads from custom visuals | Disabled |
| Allow custom visuals to get user Azure Active Directory access tokens | Disabled |
| Interact with and share R and Python visuals | Enabled |
| Usage metrics for content creators | Enabled |
| Per-user data in usage metrics for content creators | Disabled (legal obligation, advised by the DPO) |
| Azure Log Analytics connections for workspace administrators | Enabled |
| Web Content on Dashboard Tiles | Disabled (if enabled exposes org to security risks via malicious web content) |
| Power BI Tenant Settings | Configuration |
| Embed content in apps | Enabled |
| Allow Service Principals to use Power BI API | Enabled for Grp-CVT-Apps -Power BI-Admin_Apps (service principal used for generating datasets related to Power Bi Administration) |
| Allow service principals to create and use profiles | Disabled |
| Block ResourceKey Authentication | Disabled |
| Allow service principals to use read-only admin APIs | Enabled for Grp-CVT-Apps-Power BI-Admin_Apps (service principal used for generating datasets related to Power Bi Administration) |
| Enhance admin APIs responses with detailed metadata | Enabled for Grp-CVT-Apps-Power BI-Admin_Apps (service principal used for generating datasets related to Power Bi Administration) |
| Power BI Tenant Settings | Configuration |
| Enhance admin APIs responses with DAX and mashup expressions | Enabled for Grp-CVT-Apps-Power BI-Admin_Apps (service principal used for generating datasets related to Power Bi Administration) |
| Create and use Gen1 dataflows | Enabled |
| Publish Template Apps | Disabled |
| Install Template Apps | Enabled |
| Install Template Apps not listed in AppSource | Disabled |
| Review Questions | Enabled |
| Synonym sharing | Enabled |
| Block republish and disable package refresh | Disabled |
| Azure Private Link | Disabled |
| Create and use Metric | Disabled |
| Block Public Internet Access | Enabled |
| Power BI Tenant Settings | Configuration |
| Help Power BI optimize your experience | Disabled |
| Users can see Microsoft Fabric metadata in Microsoft 365 | Disabled |
| Receive notifications for top insights (preview) | Disabled |
| Show entry points for insights (preview) | Disabled |
| Create Datamarts | Enabled for Tenant Admins |
| Users can edit data models in the Power BI service (preview) | Disabled |
| Allow quick measure suggestion (preview) | Enabled |
| Allow user data to leave their geography | Disabled |
| Users can access data stored in OneLake with apps external to Fabric | Disabled |
| Users can sync data in OneLake with the OneLake File Explorer app | Disabled |
| Users can synchronize workspace items with their Git repositories (preview) | Enabled |
| Users can export items to Git repositories in other geographical locations (preview) | Disabled |
| Users can export workspace items with applied sensitivity labels to Git repositories (preview) | Disabled |
| Users can use a preview of Copilot and other features powered by Azure OpenAI | Disabled |
| Data sent to Azure OpenAI can be processed outside your tenant’s geographic region, compliance boundary, or national cloud instance | Disabled |