Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
I would like to ask, is it possible to set ODBC datasource for gateway with SLQ statement? Most of my sources in desktop version have SQL statement, because without it, it is impossible to load the query.
Solved! Go to Solution.
Hi Sk1X1,
You can add SQL Query in advance option when loading data to your PBI desktop. After you publish the report to web, everytime the data in your report need to be refreshed, PBI Service will send SQL Query to your gateway, then gateway will forward the query to your database.
Regards,
Jimmy Tao
Hi Sk1X1,
You can add SQL Query in advance option when loading data to your PBI desktop. After you publish the report to web, everytime the data in your report need to be refreshed, PBI Service will send SQL Query to your gateway, then gateway will forward the query to your database.
Regards,
Jimmy Tao
Yes, you can use Advanced options in an ODBC connection to paste in a SQL Statement, if that is what you are asking.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.