Forum Discussion

simonmoseley's avatar
simonmoseley
Regular Visitor
9 years ago

Templates using SharePoint lists

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:- Should I save my report a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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-time/td-p/50969

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

  • simonmoseley's avatar
    simonmoseley
    Regular Visitor
    9 years ago

    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?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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

      • simonmoseley's avatar
        simonmoseley
        Regular Visitor
        9 years ago

        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