Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have created some reports added some charts and slicers linking to a SharePoint site that I would like to use as a template for other subsites.
My questions are:-
Thank you so much in advance
Hi @simonmoseley,
Firstly, you can create a data source parameter in your current Power BI Desktop file, then create a Power BI Report template. This way, users can use the Power BI Report template to instantiate new Power BI Reports on their machine by choosing different SharePoint site. For more details about Power BI template, please review the following blog and similar thread.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://community.powerbi.com/t5/Desktop/How-to-create-a-template-with-a-different-data-source-every...
Secondly, what is the exact error you get? Generally, you would need to check applied steps in query editor and remove incorrect steps.
Thirdly, in this case, click on your query in query editor , and check APPLIED STEPS in Query Setting panel, some steps (for example,“Renamed Columns” ) should make changes to your columns, as long as you remove these steps, the error should go away.
Thanks,
Lydia Zhang
Hi,
thankyou for taking the time to get back to me. I thought the template was the better option and feel better for having that clarified. I will also add the paparemeter to promp the new data source.
The errors I get are warning triangles in the Queries field on the left which are expression errors the key didn’t match any rows in the table. Details Key=Record Table =Table. I click go to error then edit settings. When the Navigation windows pops up I selected the resource which is the same as the Queries on the left. On the applied steps it shows a duplicate called renamed columns1 which I delete, close and apply and all works ok until I get a site without any data in it I get a picture of a table next to the queries then when I apply and close I get Expression.Error The column id for the table wanst found. Can I get round this or will I have to populate it with some kind of demo data?
Hi @simonmoseley,
The error which you get again indicates that the column has been deleted in the data source. You should have some steps in your query that explicitly reference the deleted column. You can open advanced editor on your query, then find the deleted column in it, then correct the codes in advanced editor.
Thanks,
Lydia Zhang
Hi,
thanks again for your help. I think my issue is because its a new site, it has the same feilds but no data as yet and I will have to tell my boss we cant show anything untill all the fields have something? I dont get this error picking other subsites with Data
Below are a few screen shots which may help explain myself better
At this point I go to the error and pick the same table I then get this
When I clicked Renamed Columns I get this
@simonmoseley wrote:
Hi,
thanks again for your help. I think my issue is because its a new site, it has the same feilds but no data as yet and I will have to tell my boss we cant show anything untill all the fields have something?
Hi @simonmoseley,
Yes. Or you would need to delete "Rename Columns" step in Applied steps.
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |