Need Help: Error 8657 accessing Dataverse contact table in Power BI/Excel
Hi Experts, I need your help with this issue (Error 8657 accessing Dataverse contact table in Power BI/Excel). Microsoft Support just responded that it's a backend issue and they're unable to do anything about it. It's been a week since we started getting this error. Please help me to resolve it and guide me on what we can do next. Regards.
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!
Ways to connect Power BI with SAP Success factor
Hi Team, I didn't come across any official connection between SAP Success Factor with Power BI. Please help us out is there any connection that we can establish between with SAP Success Factor to generate the reports in Power BI. Looking forward to your response.
Extract data from a chart on website
Hello everyone, I woudl like to ask for an advise how to extract data from a specific object (Chart) on a website. My intension is to get daily values of mutual funds into Power BI, howover so far I couldn't find any way how to do it. Is it even possible? https://finance.yahoo.com/quote/WPLCX?p=WPLCX Thanks a lot! Jan
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 advanceFYI: MSAccess connector cannot use queries that have the NZ() function
Hi All, Found this out the hard way, as the query and all child queries do not appear in the list of objects when connected to the Access Database as a source. solution is to replace the convenient NZ() function with an IIF() statement original Nz(MAP.chkCOE,"n") Replacement IIf(Trim(MAP.chkCOE) = "" or IsNull(MAP.chkCOE), "n", MAP.chkCOE) Cheers Andrew
