https://community.databricks.com/t5/data-engineering/log-data-from-reports-in-powerbi/m-p/83577#M36959 <P>Where to find log data from PowerBI? I need to find what tables are being used in my PowerBI reports that are pointing to Databricks. I tried&nbsp;system.access.audit but I'm not finding new data when I refresh my report</P> Tue, 20 Aug 2024 09:46:35 GMT ksenija 2024-08-20T09:46:35Z https://community.databricks.com/t5/data-engineering/log-data-from-reports-in-powerbi/m-p/83577#M36959 <P>Where to find log data from PowerBI? I need to find what tables are being used in my PowerBI reports that are pointing to Databricks. I tried&nbsp;system.access.audit but I'm not finding new data when I refresh my report</P> Tue, 20 Aug 2024 09:46:35 GMT https://community.databricks.com/t5/data-engineering/log-data-from-reports-in-powerbi/m-p/83577#M36959 ksenija 2024-08-20T09:46:35Z https://community.databricks.com/t5/data-engineering/log-data-from-reports-in-powerbi/m-p/108710#M43125 <P><SPAN><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/96755">@ksenija</a>&nbsp;&nbsp;</SPAN></P> <P><SPAN>To enable ODBC logging in PowerBI, go to </SPAN><SPAN>C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Spark ODBC Driver</SPAN><SPAN> folder and create or edit the file </SPAN><SPAN>microsoft.sparkodbc.ini</SPAN><SPAN> and update as below: </SPAN></P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD> <P><SPAN>[Driver]</SPAN></P> <P><SPAN>LogLevel=6</SPAN></P> <P><SPAN>LogPath=&lt;available folder location where the logs will be generated&gt;</SPAN></P> <P><SPAN>LogFileSize=1000000000</SPAN></P> <P><SPAN>LogFileCount=10000</SPAN></P> <P>&nbsp;</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Regards</P> <P>Allia</P> Tue, 04 Feb 2025 07:52:11 GMT https://community.databricks.com/t5/data-engineering/log-data-from-reports-in-powerbi/m-p/108710#M43125 Allia 2025-02-04T07:52:11Z