Forum Discussion

XuanHau's avatar
XuanHau
Icon for Helper I rankHelper I
2 years ago

Semantic model of data from Azure Log Analytics

Hi guys, I have a couple of questions about data retrieval from Azure Log Analytics: I have a table ABC on Log Analytics with a total of 10 columns. I created a query using data from 3 of these 10...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi XuanHau 


Please try the following steps:

1.Open your Power BI Desktop file that is connected to SM1.
2.Go to the 'Home' tab and select 'Transform data' to open Power Query Editor.
3.Edit the query to include the additional columns from table ABC.

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

XuanHau's avatar
XuanHau
Icon for Helper I rankHelper I
2 years ago

Hi Anonymous 

If I open the PBI desktop file (of my current report) connected to SM1 (already on the PBI workspace). It wont show SM1 in the Power Query Editor.

If you mean downloading SM1 and opening it in PBI Desktop, we can do that. However, when I publish this semantic model again, it won't replace the old one already on the PBI service