Columns missing in FOCUS (1.0r2) Cost Export #1460
-
|
I am unable to find the new columns available in the Focus 0.8 Power BI report. I’m exporting cost data to a storage account and then building a custom report, but I noticed that many prebuilt columns from the Focus 0.8 version are missing in my export. Example: Columns Present FOCUS 0.8 Report.
I'm using cost export from Azure port with FOCUS (1.0r2)
|
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 5 replies
-
|
Those columns are not part of the FOCUS dataset. They are added as part of the query that Power BI uses to prep data. That said, I just validated that they exist in both storage and KQL reports, so I'm not sure why you wouldn't see them 🤔 Can you share what you see? |
Beta Was this translation helpful? Give feedback.
-
|
How can I calculate these columns? I'm trying to build a similar report using the FOCUS dataset with Azure Cost Export and Fabric. Is there a report template similar to the Storage and KQL reports? |
Beta Was this translation helpful? Give feedback.
-
|
Fabric is a bit of a different story. Fabric has limitations that don't allow you to use PowerQuery in the same way. I've heard it's possible to use DataFlow Gen2, but I've never done it myself. That might work with what you have here, but I can't say for sure. You can look at the code in either storage or KQL reports and repeat that in a notebook or ADF pipeline. Personally, I would suggest using Data Explorer or a KQL database in Fabric. I find that a much simpler approach. You can also use FinOps hubs with Data Explorer and then connect to that from within Fabric. We're planning to use KQL databases natively in Fabric but aren't there yet. To answer your question about how to reuse the queries -- even tho it may not help you with Fabric -- here's how I'd generally respond: The simplest option is to build your report on top of what's provided in the FinOps toolkit. But if you want to copy it into your own report, you can open the Costs query in the advanced editor and copy the specific code you need. Just note we've applied some tricks in an attempt to improve performance, so you'll see nested steps that you may need to parse out. In this case, you'll see a bunch of Hope this helps! |
Beta Was this translation helpful? Give feedback.
-
|
@gowtham9394 are you able to make this workable based on above response? I am also working on export of FOCUS dataset with MCA agreement to my storage account however after pointing to dataset there are missing columns. |
Beta Was this translation helpful? Give feedback.
-
|
I implemented this logic in the notebook to calculate the new column. |
Beta Was this translation helpful? Give feedback.
-
|
Out of curiosity, any reason why you don't just use Data Explorer in Fabric? |
Beta Was this translation helpful? Give feedback.
Fabric is a bit of a different story. Fabric has limitations that don't allow you to use PowerQuery in the same way. I've heard it's possible to use DataFlow Gen2, but I've never done it myself. That might work with what you have here, but I can't say for sure.
You can look at the code in either storage or KQL reports and repeat that in a notebook or ADF pipeline.
Personally, I would suggest using Data Explorer or a KQL database in Fabric. I find that a much simpler approach. You can also use FinOps hubs with Data Explorer and then connect to that from within Fabric. We're planning to use KQL databases natively in Fabric but aren't there yet.
To answer your question about how to reuse th…