Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ccleverley
Regular Visitor

When data loaded via API, for Date fields the Visualization As Year, Quarter, Month, Day is missing.

 

I load the dataet,table and table data via an API.

 

On the Cloud I go to the Steamable data sources. (Dutch GUI - I may not have the correct English name for that.)

 

I create a new chart. Line Diagram. I drag a date field to the AS part of the chart. 

 

If I do that with a table that I created in the Desktop then I get the very useful Year Quarter Month Day helper columns underneath the Date field that I just dropped.

 

With data loaded from the API I do not get these helper fields - the date stays as a flat date. (And lets be honest - noone is going to do a serious line chart on single dates.)

 

The workaround would be to load year, year-month and year-quarter fields. But that is not very user firendly....

 

 

1 ACCEPTED SOLUTION
TedPattison
Employee
Employee

If you created a dataset and a table with the Power BI REST API, you have created a streaming dataset which is different than the datasets you created when uisng the data import model in Power BI Desktop. There are several cool features for imported mode datasets that are not available on streaming datasets such as the automatic data heirarchy support.

 

The solution is to modify the code that is adding rows into the table in the streaming dataset. Whjen you create the dataset and table, add new columns for Year, Quarter and Month and write a bit more code to add those extra columns when calling into the Power BI REST API to create new rows.

View solution in original post

2 REPLIES 2
Eric_Zhang
Employee
Employee

@ccleverley

That seems the limitation for Streaming dataset. You can check this idea stream date field hierarchy and vote it up.

Also check a similar thread here.

TedPattison
Employee
Employee

If you created a dataset and a table with the Power BI REST API, you have created a streaming dataset which is different than the datasets you created when uisng the data import model in Power BI Desktop. There are several cool features for imported mode datasets that are not available on streaming datasets such as the automatic data heirarchy support.

 

The solution is to modify the code that is adding rows into the table in the streaming dataset. Whjen you create the dataset and table, add new columns for Year, Quarter and Month and write a bit more code to add those extra columns when calling into the Power BI REST API to create new rows.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.