Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I am new to PowerBI and thought i had flexibility to import my powershell script via powerbi's api-which works..but in the process I do not have access to the MODELING tab, and all the flexibity that, that allows. Instead i have tried cleaning up data, by creating measures. i am now unable to use those measures in my axis for charts and graphs.
Is there a way to take a measure and use it in a chart? For example I had a column for data and time. I removed time in the Measure, and now i want show the historical performance of an item just using the date.
OK, trying to understand what you are doing here. You are saying that you created a data model using the Power BI api now you are working with it in the Service? Currently, you cannot edit or change the data model in the Service. Then are you saying that you connected Live to the Power BI data model in the Desktop and created measures? I'm confused by your process.
Typically when people start out, they use the Desktop and import data, create their data model with calculated columns and measures and often reports and then publish to the Service. That is probably, by far, the most common use case. Then the second most common is using Power BI Desktop to connect to a source via Direct Query. You can do certain things only in the Service but you will be highly limited when it comes to data modeling.
Sorry for the confusion. I used Desktop to create the reports. While in Desktop i realized that, unlike using a database, with my powershell data i was unable to use the Modeling tab to format the data columns as desired-all the values are grayed out. That is when i created the measures to get the desired values in each column.
Right now, I have fields for Date & URL, then a few numerical values for URL performance. The URL and Date our measures i created to remove unwanted data from each field...now i am trying to figure out how to use those measures to display my data.
I guess my question is do i need to clean the data prior to getting it into PowerBi desktop, or is there a way to allow those measures to be used in the axis of a chart, for example.