amadeann
Advocate I
6 years ago'@Philip Connecting to BigQuery via ODBC is just a matter of downloading and configuring the ODBC driver. Since around 2 months the driver is available for download directly from Google website: https://cloud.google.com/bigquery/partners/simba-drivers/ Configuration is fairly straightforward. Once you do this, you can simply select the ODBC as data source in Power BI and write the SQL query to get the data (same as you'd do in the web interface). The only problem I am finding with this solution is that the data is loading extremely slowly (queries take more than 10x longer to execute compared to web interface).
Recent ideas
SQL Analytics Endpoint host name - CNAME or defined alias
The host name for a SQL Analytics endpoint is ugly. They look like this: random_ugly_alphanumeric-random_ugly_alphanumeric.datawarehouse.fabric.microsoft.com The first segment looks like it...Mike_Diehl1 hour agoNew MemberNew27Views2likes1CommentFix links generated in multi tenant setups
When I log into Fabric, and I have access to multiple tenants, the links generated for things like monitoring URLs in pipeline runs do not include "ctid=<tenantguid>" query string value, which appear...jwisemanfs4 hours agoNew MemberNew3Views0likes0Comments