Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello experts,
I made a PowerBI report from a Sharepoint List using the menu from Sharepoint List "Integrate\Power BI\Visualize the list".
I went editing and "Publish to list". Everything work fine. Now users who have access to the list can go to that menu and open my report.
But I cant add measurements via the web interface, I tried to add calculated column in the Sharepoint List so I would be able to use the web version of PowerBI but all calculated column from sharepoint list are considered as text in PowerBI even if its result is set to number.
So, I downloaded PowerBI Desktop to be able to add measurements fields. Everything work but I cant publish the report back to the Sharepoint List. I want my report accessible from the list.
So following this experience, I have 2 questions.
1- Is it possible to make PowerBI consider the calculated columns from the sharepoint list as numbers?
2- Is it possible to publish a report to a sharepoint list to make it available throught the "Integrate/Power BI/..." menu?
Solved! Go to Solution.
I have read the web page you mentionned about the REST. Seems to be for web site developpers using javascript or C#. I just want to be able to to publish the report to the "integrate" section of the sharepoint list with few clicks.
I will have to find a easier work arround.
Thinking about using power automate on new item created/modified on the list to update columns values so I will be able to use these values with the web PowerBI and use the "Publish to the list" button as I cant do that with the Desktop version.
Just sad that you just cant use calculated column from Sharepoint List in PowerBI or add measurement in the web PowerBI.
Hi @DS1060 ,
Current sharepoint connector seems not work for culated columns, please use rest api to get data from sharepoint.
Working with folders and files with REST | Microsoft Learn
Follow below steps to connect to your SharePoint List
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have read the web page you mentionned about the REST. Seems to be for web site developpers using javascript or C#. I just want to be able to to publish the report to the "integrate" section of the sharepoint list with few clicks.
I will have to find a easier work arround.
Thinking about using power automate on new item created/modified on the list to update columns values so I will be able to use these values with the web PowerBI and use the "Publish to the list" button as I cant do that with the Desktop version.
Just sad that you just cant use calculated column from Sharepoint List in PowerBI or add measurement in the web PowerBI.
Thank you very much for your awnser. I will take a look on that REST service documentation.
Seems to be the solution.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |