Issue Opening Power BI Report from Sharepoint
Good Afternoon, Power BI newbie here. I'm getting a connection issue trying to open a Power BI Report from Sharepoint. Any idea what the issue could be? Two of my reports open just fine, but one is giving me the attached error. Any assistance would be greatly appreciated. Thanks.Sharepoint List: Visualize The List - Something went wrong
Hi, Has anyone come across below error message and how they remedied it? Basically I'm trying to use the "Visualized The List" feature in Sharepoint and whenever I do it I get a message that says "Something went wrong"... Any idea on how to fix this? Something went wrong We're having trouble visualizing your SharePoint list data right now. Please try again later or contact support. If you contact support, please provide these details Activity ID: ab038106-d380-45db-8cb8-6d4e1c9cf2a5 Request ID: dd7cbb2b-dfc0-94fb-e72e-a1331f6089b2 Correlation ID: 6ab903df-f837-acad-d6cf-3ba370b4b92f Status code: 400 Time: Thu Jun 13 2024 08:34:35 GMT-0400 (Eastern Daylight Time) Service version: 13.0.23465.65 Client version: 2406.1.19574-train Cluster URI: https://wabi-canada-central-redirect.analysis.windows.net/
Organizational account credentials from Power BI Server?
Hi, I've created a report with a Sharepoint Folder data source (specificaly, an excel xlsx file in a folder of my Sharepoint site). My Sharepoint is hosted on Sharepint Online and I access it via Organizational Credentials. I've been able to do it in Power BI Desktop for Report Server (October 2017). Once I publish my report to POwer BI Server, I go to "Manage > Data Source" , there in Credentials I can only choose Anoymous or WIndows Authentication. Is there a way to have a report pulling data from Sharepoint Online from Power BI Server as of now? (and have it refresh on a scheduled basis). THe idea is to have some select users edit data in the EXcel file, and management can open the report done in POwerBI. (I'd like to avoid having to open the report in PowerBI Desktop and republish it everytime there is a change in the data source, which is what I am doing for now.)
exporting and importing sharepoint sites
Good morning everyone! I've set up a SharePoint site with various security groups, flows, forms, and PowerApps linked together to collaborate. What I'd like to achieve is the ability to export this setup and import it into another environment. I've noticed that through Power Admin, flows and PowerApps can be saved. However, SharePoint sites cannot be saved using this method. I've read online that this might be achievable with PowerShell using the Export-SPWeb command. However, I'm not entirely clear on the exact steps to follow. Does anyone have experience with exporting and importing SharePoint sites? Could you please provide a step-by-step guide on how to do this? If there's an alternative method other than the command mentioned above, I'd also appreciate hearing about it. Thank you in advance!
fail to connect sharepoint Data source in power bi report server
Hi everyone: I select sharepoint folder as datasource when i make report in power bi desktop. I can refresh it in the power bi desktop.After i upload the report on the report server. I try to connect the datasource and schedule refresh.Authentication Type has two options,anonymous and window authentication. So i think it is sharepoint on premises.Because if it is sharepoint online.it shouldn't have these options.However, unexpected error encountered when i choose the two options. I use my corporate domain and username when the authentication is windows authentication. The same error .Log on failed. Ensure the user name and password are correct. I wish you can help me to solve this issue. You can save my life!How to Edit and Save Power BI Report embedded in Sharepoint online.
Hi Team, I want to edit and save a Power BI report which is embedded in Sahrepoint Online. What is the possible way to do this? I have tried Sandbox developer Playground. In that i'm able to get the edit and save option Javascript Code, but no idea how to use that in Sharepoint online. Thankyou in advance
Backing out from quarterly to monthly
Help me Rhonda! <---Also, not sure if Dax is the right place for this post, so please let me know if I should repost elsewhere. Our organization collects performance measure data from internal program areas via Microsoft Power Apps. That info is stored in about a dozen SharePoint Lists. Data is entered in monthly (sometimes more often but that is because people make mistakes and have to re-enter the data). This shows in the lists pmd_element data. The App was originally designed to report on a quarterly basis, so that info gets rolled up to that time period for what was approved by the manager and shows in the pmd_measure data List. You'll see that the Numerator/Denominator columns are actually references to rows in the pmd_element data List, so they are referencing the entries that were ultimately approved and are legit. How can I back out of this to show the monthly approved entries though? I've been able to do stuff on this quarterly basis, but now leadership wants it monthly and I'm losing my mind. The person who created the App left and I have hardly any experience in that realm. On top of that, I also need to account for the fact there are different types of measures (e.g. percentage of calls taken vs a sum of number of complaints received) and that some measures are cumulative (aggregating for the year) and others non-cumulative (only needing to show for that quarter or other time period). There are other lists like pmd_target and pmd_measure that have columns to help with that aspect, but I'm lost on how to handle those as well. Anyway, what do you think? What can I do? What extra info can I give you to help you help me 🙂
Break out months from a single column and assign to appropriate date format
Hello! I am working with SharePoint lists, where they are capturing performance measure data from different areas at my organization. They currently focus on quarterly data but are wanting to move to looking at it on a monthly basis, when possible. Some groups report monthly, and others quarterly or annually, so the visualization would need to adjust depending on what the reporting requirement is. Monthly data is stored within two indivdidual columns (numeratorIDlist and denominatorIDlist) and separated by commas. Typically this will have three values representing the quarter, but there are also some groups that have monthly performance reporting requirements, and if it is a cumulative measure (shown in the pmd_target SharePoint list) will have more values as the year goes on (e.g. 9 values in the comma by quarter three, because 3 months per quarter for 3 quarters.) The list, pmd_measure, identifies which performance measures are reported on a monthly, quarterly or annual basis (m, q, a). There is a SharePoint list (pmd_fiscal calendar) that has month, quarter and calendarmonth, although I haven't really incorporated that very well into the model so far. This thing is crushing my brain. Any help is greatly appreciated!!!!!
