amadeann
6 years agoAdvocate I
'@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
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v56 minutes agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401974 hours agoFrequent VisitorNew5Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf14 hours agoFrequent VisitorNew48Views3likes2Comments