Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Dear All
I have an excel 2016 spreadsheet where i have information, someone previously set up a power query and pivot table, however i am unable to refresh the data I have changed the file path but the data where the the pivot table and power query is from is from is somewhere else and need to change it so i can refresh
Hi @Kaz28EN, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
hI
No this is still not working, when i unpivot and rename it says this name already exists, please advise how i can attach spreadsheet for someone to take a look at this, i would be grateful
Hi Thank you for the screen shots, however the sheet is not straight foward, i have created a conditional format for the sampling results dependant on value (key within spreadsheet) and have mutliple worksheets, i am trying to show a pivot table that identifes the site, type of sample (quarterly/resample), sample date, quantity of result interretation (and possibly getting the pivot table to match the conditional format in result interpretation.
Thank you in advance
Hi @Kaz28EN, thank you for reaching out to the Microsoft Fabric Community Forum.
Please follow below steps:
Please check the attached document for your reference.
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hi
Thank you for your response i have tried but the pivot table is bringing up all the sample results as sample results 1, 2, 3 where in the pivot table i would like it under just the one header rather than having to select about 20 sample results, if this makes sense? i Have tried putting all the data into one master sheet but it is still messy on the pivot table.
How do i attach as the system keeps saying XLS not supported?
Hi @Kaz28EN , Thank you for reaching out to the Microsoft Community Forum.
Try this:
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Hi @Kaz28EN, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Hi @Kaz28EN, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Hi @Kaz28EN, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Hi
No i cant get it work, all i need the spreasheet to supply a pivot table so we can report on different months of what was sampled etc i have tried a new spreadsheet from scratch but i am struggling with it
Hi @Kaz28EN, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Hi @Kaz28EN , thank you for reaching out to the Microsoft Fabric Community Forum.
Thank you @Akash_Varuna for your prompt response.
The error message you're encountering indicates that there is an issue with the connection to the external data source in your Power Query. Specifically, it mentions that the source database or table does not exist, or you do not have access to the data source. Additionally, there is a mention of an argument mismatch in a function.
Please consider following below steps:
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Thank you for your reply unfortunately i think the data base from the person that set the power query up no longer is valid.
Would anyone be able to assist and set up a new one for me or just even a pivot table.
I need a pivot table to show the months and locations of samples carried out with results so we can evaluate failures etc
Hi @Kaz28EN , thank you for reaching out to the Microsoft Fabric Community Forum.
Please follow below steps to set up Power Query and Pivot Table:
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hi @Kaz28EN , thank you for reaching out to the Microsoft Fabric Community Forum.
If I am understanding it correctly, you want help setting up pivot table and power query. To do this, please follow above steps (of my previous reply).
For your reference I have attached screenshots of doing this based on a sample data.
If this doesn’t help, please consider sharing your data if possible.
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Thanks you for this, however it still keeps bringing up the folllowing. The pivot table and power query was set up by someone else in the microsoft community
Hi , Try these
Open Queries & Connections from the Data tab, right-click the query, select Edit, and update the file path in the Power Query Editor.
Click Close & Load to save changes after updating the data source.
Ensure the Pivot Table references the updated query by selecting Change Data Source under PivotTable Analyze.
Use Refresh All in the Data tab to refresh both the query and Pivot Table.
User | Count |
---|---|
20 | |
11 | |
9 | |
8 | |
7 |