Forum Discussion
Displaying data from SharePoint list into a simple bar chart
Okay I've figured that part out now, an question I have now is that my plan was to publish this dashboard (once finished) and then use power automate so any new data put into the sharepoint list will automatically update into power BI, will this work with these columns unpivoted?
Hi Tom898
You can use Power Automate to trigger a Power BI dataset refresh which means that the semantic model in the service gets refreshed with the updated data but as per documentation, the dataset refresh limit is 16 per day inclusive of API and scheduled refresh. If you wish to create a streaming/realtime dataset, you can't use Power Query so no unpivot. Here's how to create a streaming dataset with Power Automate + Power BI + SP List - https://www.youtube.com/watch?v=jmJJHFGwWFc&ab_channel=KeaPointTechTips
But honestly, I find, the auto-update as the sharepoint list is updated an overkill. I'd be fine with getting the most updated report as of yesterday or as of the last few hours but not every second.
I mean the sharepoint won't be getting that many updates, just when someone carrys out an audit. So am i unable to present the date in thr format I want while having it automatically update?
If you are within the API limit, you still can automatically trigger a semantic model refresh. It's just that if you want more than that, you have to pay more.
Okay. I still don't really understand your orignal solution, how do i display the data unpivoted. My main problem is that there isn't just a normal bar chart, they're all clustered or stacked