sql database

29 Topics

Google BigQuery Mirroring in Microsoft Fabric: A Step-by-Step Guide
In this blog, we will walk through how to mirror Google BigQuery tables into Microsoft Fabric using the Mirrored Google BigQuery (Preview) feature. This allows organizations to operationalize data across cloud platforms without building or maintaining complex ETL pipelines. Let’s get started.
suparnababu8
9 months ago Place Databases Community Blog
47KViews
18likes
10Comments
How to Mirror Google BigQuery Data into Microsoft Fabric | Step-by-Step Tutorial
In this video, I walk through the complete process of mirroring Google BigQuery tables into Microsoft Fabric using the Mirrored Google BigQuery (Preview) feature. This allows seamless real-time replication of your data from GCP into Microsoft Fabric’s OneLake—without writing ETL pipelines. What You’ll Learn How to set up BigQuery mirroring in Microsoft Fabric How to connect BigQuery using a Service Account How automatic table synchronization works How to query mirrored tables using SQL in Fabric How new tables in BigQuery are automatically replicated Why Use BigQuery Mirroring? No manual data movement or pipelines required Unified analytics across cloud platforms Near real-time data freshness via CDC Query directly in Power BI, Notebooks, and SQL Analytics Endpoint If you found this helpful, please like, share, and subscribe for more Fabric & Data Engineering tutorials Comment below #MicrosoftFabric #GoogleBigQuery #BigQueryMirroring #FabricMirroring #OneLake #CloudAnalytics #DataEngineering #ModernDataStack #RealTimeDataSync #PowerBI #SQLAnalyticsEndpoint #GCP #Azure #DataWarehouse #AnalyticsEngineering #NoETL #CDCReplication #DataIntegration #EnterpriseData #DataPlatform #FabricWorkspace #GoogleCloud #MicrosoftAzure #DataAnalytics watch?v=Pqllan2Rc4o
suparnababu8
5 months ago Place Webinars and Video Gallery
18KViews
6likes
4Comments
Databases in Fabric - 7 Quickstart tips
In this article, I will be sharing 7 tips to quickstart & boost your databases in Fabric development
olivs
1 year ago Place Databases Community Blog
14KViews
9likes
6Comments
Best Option for Power BI Data Repository
The current Finance role that I am in involves standardizing reports for a wide audience to use. I have developed multiple Power BI reports that others are using, and I want to have a data repository for all current and future Power BI reports. The current location of my data is on my personal computer, but I want the data to be available for other analysts to grab when they want to develop their own Power BI reports/analysis. Unfortunately, I cannot connect directly to SAP HANA (IT will now allow it) but instead have to query the data out of SAP HANA using Analysis for Microsoft Excel and connect to flat files/workbooks that hold the data. I am currently trying to decide on the best location to house the data for the Power BI reports, and I am currently looking into using SharePoint, SQL database, a shared server, or Azure. I think Azure is the least likely option due to cost and the required involvement of IT, but I still want to include it as an option, nonetheless. Is there someone that can give the pros and cons of each (to use as a data repository) for the organization’s Power BI reports? I have never used SQL or Azure as a data connection in Power BI, so any information would be helpful. It is just me that will be maintaining this data repository, so I am trying to keep it simple but efficient. Ideally, I would not be adding a week’s working hours as a database administrator on top of my current role. Below are what I have so far as my options: SharePoint- This is the option I am leaning towards mostly as of now. Pros -It would not require an on-premises data connection for Power BI Service. -Can use a macro to refresh the queries held in each excel workbook that would be held on SharePoint and then refresh the reports in Power BI Service -The team I work for manages the SharePoint site for the organization -It would not require additional cost unless we start to get close to the storage capacity of our SP site Cons -Takes a long time to bring data into Power BI Desktop and slower refresh connecting to an online data source -Can potentially be a lot of excel workbooks and folders SQL database Pros -Can use Select statements within Power BI reports to gather only the data I would need instead of pulling in an entire dataset (Not a huge benefit I think but a benefit, regardless) -Additional capabilities in Power BI because of connection to database? (Direct Query?) -Can create relationships between datasets (Not sure if I would use/need this feature) Cons -Would have to use an on-premises data connection for Power BI Service. Would maybe require a virtual machine to run scheduled refreshes. -Would require the skill and time to manage the database Shared Server Pros -Would be faster than using SharePoint (Online data repository) Cons -Would have to use an on-premises data connection for Power BI Service. Would maybe require a virtual machine to run scheduled refreshes. Azure- Do not know too much about this option. Pros -Can handle a lot of data (More than a SQL db I believe) -Additional capabilities with Power BI? -Would I need an on-premises data connection in Power BI Service for this, since the data is housed in the cloud? Cons -Most complex solution -Costly -Would most likely require assistance of IT
Solved
astanfo
5 years ago Place Report Server
13KViews
0likes
13Comments
Announcing SQL database in Microsoft Fabric public preview | Data Exposed
Learn how we are building AI apps faster and easier than ever with the Public Preview of SQL database in Microsoft Fabric. Learn more: https://aka.ms/announcingsqlfabric watch?v=uYBIBZDHAeg
mamathews
1 year ago Place Webinars and Video Gallery
10KViews
7likes
1Comment
Azure SQL, Copilot and SQL Server 2025!
That's a big one, SQL Server 2025 has been announced! Let me talk you through some of the highlights from my point of view.
Reitse
1 year ago Place Databases Community Blog
9.9KViews
5likes
0Comments
Dive into SQL in Fabric with Live Expert Guidance | Learn Together Series
Keeping up with all the new features and technology in Microsoft Fabric can feel overwhelming. That’s why we’re excited to bring you a live, 6-session series designed to make learning easier and more interactive. Whether you’re just getting started or ready to dive into advanced topics like performance monitoring and tuning, this series has something for everyone. You can join us for just one session or stick around for the entire journey—it’s up to you! Plus, with Microsoft Fabric experts leading the sessions, you’ll have the chance to get your questions answered in real time.
slindsay
1 year ago Place Databases Community Blog
9.6KViews
24likes
6Comments
Scheduled refresh is disabled due to no credentials for at least one data source - SQL server
Hi, I got a report which have a source on SQL server. When updating data in Power Bi Desktop it works properly, when trying to refresh on published report, it doesn't work - system show information: "Data source error Scheduled refresh is disabled due to missing credentials for one or more data sources. To restart the refresh, go to the settings page for that dataset and enter credentials for all data sources. Then reactivate scheduled refresh. Cluster URI WABI-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net Action IDe819732a-d888-42ad-8439-db86caff9c73 Request ID5553c803-90c0-9f8d-1d62-bbc9461d4360" More over, when going into settings, "Data source credentials" is not active (light grey font). How can I solve it? Best, Krzysztof
Solved
KrzysztofPas
4 years ago Place Report Server
8.8KViews
0likes
2Comments
Sql server not connecting through power bi in Virtual Machine
Hello Members, I am unable to connect to sql server database from my power bi which is installed in my VM. So basically I'm under client;s vm which has Power bi Desktop and from there I am unable to connect to their sql server database. Please look at the SS for error. Error Message:
Solved
Rt-idsp
4 years ago Place Report Server
7.4KViews
0likes
2Comments
Fabric Monday 60: Fabric Databases
Discover more about Fabric Databases and how to migrate Azure SQL Databases to Fabric Databases watch?v=UcD9vKZsz2o
DennesTorres
1 year ago Place Webinars and Video Gallery
6.5KViews
2likes
0Comments