SharePoint - Integrate List to Power BI - Visualize List - not showing all fields
I have several sharepoint list that I'd like to visualize with Power BI. I'd like to use the Visualize List feature in Sharepoint as a quick way to build a simple dashboard within the list. When I attempt to build the report only a few fields show up in the dataset. One list it is the first 9 fields available, on the other it is a random 9. Ironically, this morning I attempted the same thing that wasn't working for months and found all 25 fields in the dataset showing but when I started to edit the report it reverted back to the 9 that was originally provided. Does anyone else have this issue or can help identify a solution. Details: -SharePoint Tennent has Power BI integreation enabled -I am running Power BI Pro -I have full read/write access to the data
SharePoint list Refresh options
Hello Team, I am new to power bi. Can you please help me with a query regarding refresh option with SharePoint list? I am creating a dashboard based on SharePoint list. Connected to Power BI desktop and published to Power Bi Service. I can see scheduled refresh once in a day. Do we have any more frequent refresh available? Thanks, PraveenProblems pulling SharePoint data with Persona or Choice data type to Power BI
Hi everyone, I'm using a SharePoint list to track work items. For consisntency I use the Person or group data type for "Requestor" and "Assigned To" and Choice data type for "Output type". I would like to build a PM dashboard with this data but when I connect to Power BI using Online Services, "Sharepoint list" i get a generic [Table] or [List] for anything that's not in a text of number data type. If I go ahead an visualise the values are not shown , I only see a "list" item in any X axis i make. Does anyone know how I can pull the actual values or the tables that have those values so I can build a model? Thank you in advance.Delete the first 10 rows of each file on a "multiple file" table
Hi all, I have a quite specific question for you : I made a query with parameters to get the values of multiple excel files (hosted on sharepoint) into one single table, that I will call "multiple file table" or "consolidation table". Because all these files have exactly the same structure, I can see them in one single Power BI Table with same columns for each. In the applied steps of the Table, I had to remove the First 10 rows of the Excel file (it contains useless values), but it just did it for the 1st file I injected. What I would like is : create a formula to remove first 10 rows each time my Table is processing a new file. (What I did until now is a series of "= Table.SelectRows(#"Renamed Columns", each [field1] <> null and [field2] <> null" ... but it is quite ugly and not developer friendly.) I hope it is clear for you. Many thanks in advance
