MySQL Connector - Direct Query
Hi Team, From Power BI, I'm using the MySQL connector to connect to the MySQL database. However, I do not see an option to choose the data connectivity mode as DirectQuery. The connector is automatically using Import mode. When I checked the Microsoft documentation, it appears that the MySQL connector is supported only in Import mode. Could you please confirm whether this is expected behavior? Is it true that Power BI does not support DirectQuery connectivity with MySQL using the native MySQL connector? Thanks in advance!
Inserting a list of value into a Snowflake query
Hi, I currently have a list of values which dynamically change either in value or length of list. E.g. Kjn23409u Nskjnfwo123 Slmdfwo10239 I then have another query which filters an extremely large database (Over 10 million rows) based on the above list of values. SELECT * FROM X_Database WHERE ITEM_ID in (‘Kjn23409u’,’ Nskjnfwo123’,’ Slmdfwo10239’) I currently have to update the list of values in the SQL whenever the original list updates, however I would like to have this done automatically using power query. My question is it possible to place the first list of values generated from a query from an excel file into the snowflake sql query using the advance editor. E.g. Create a variable which reference another query (that is a list of value) and then place the variable in to the sql query. Current Query let Source = Value.NativeQuery(Snowflake.Databases("Warehouse","Warehouse"){[Name="Database"]}[Data], " SELECT * FROM X_Database WHERE ITEM_ID in (‘Kjn23409u’,’ Nskjnfwo123’,’ Slmdfwo10239’)” , null, [EnableFolding=true]), in #"Table" Idea Let VAR Item_id_list = query1 Source = Value.NativeQuery(Snowflake.Databases("Warehouse","Warehouse"){[Name="Database"]}[Data], " SELECT * FROM X_Database WHERE ITEM_ID in Item_id_list" null, [EnableFolding=true]), in #"Table" Thank you in advance
Access.Database and Web.Contents on Macs
Hi, Any expert on Power Query for macOS there ? 😉 I have an Access database in my Dropbox pro folder and I would like to to be able to work on it on my Mac when I am at home. So to connect the Access database to PQ without a local path, I can manage through Web.Contents() I can also manage to have it on another PC since this is not locally dependent on my PC at work However, I hav tried to use Web.Contents() in my Mac, I do see the file but I cannot drill down to the table as I cannot use the module Access.Database Any help, lead or workaround would be greatly appreciatedQuickly Filter Out Salesforce Object Fields
I have recently connected to Salesforce Object, however my opportunity or account object consist alot of fields. Is there a way to quickly filter out the object fields without writing any advance editior syntax ? The current way that I am doing is by manually removing the object one by one and it is very time consuming.
Can't connect to Salesforce Reports
I've been able to connect to our Salesforce objects forever now without issue. I've now encountered a situation where I need to instead connect to reports and it just isn't working. Whenever I try to connect it just sits here and spins and never moves forward: Has anybody ever experienced this? I can't think of what the issue could be.
