Forum Discussion

pzeller's avatar
pzeller
Frequent Visitor
9 years ago
Solved

Change report connectionstring and credentials

We have  multitenant system and we are trying to use the same report for each, but with updating the connectionstring/credentials. We have a default report that was built in Power BI Desktop based of...
  • pzeller's avatar
    pzeller
    9 years ago

    We figured out the issue we were facing. Eric_Zhang, you are correct that all the code works and we knew that, but the part that was giving us trouble was then viewing the report itself.

     

    SOLUTION:

    Our problem was due to having a multitenant system, our data structures weren't always the same, meaning in one DB we could have 10 columns and in the other we could have 12 columns. This causes the report to fail and unfortuntely only gives a very generic error message. There does not appear to be a work around for this, but for our situation we were simply able to make a view with a standard set of columns that will be used across all tenants. This solved our problem.

     

    SUGGESTION:

    These error messages we are receiving are very minimal and cause us to run around searching every possible issue. If the messages were a little more detailed solving the issue would be a much easier task. Please update your error messaging to be more detailed and/or applicable to the issue at hand.