microsoft / coe-starter-kit

Other
752 stars 225 forks source link

[CoE Starter Kit - BUG] CoE update in Power BI by using Power BI Desktop is failing.... #8065

Closed reymesEDC closed 7 months ago

reymesEDC commented 7 months ago

Does this bug already exist in our backlog?

Describe the issue

Trying to update CoE in Power BI by using Power BI Desktop application. Two warnings are displayed after uploading "Production_CoEDashboard_March2024.pbit" file in Power BI Desktop. One of the warning says: "One or more objects need to be manually refreshed". The other one says "Some of the tables have incomplete or not data". Each warning has a button on the side to actually carry out the refresh. The first one executes without issues, but the second one triggers Error message :"2 queries are blocked by the following errors": AI Builder Models, We cannot covert the Null value to Type Text; Power Apps, We cannot covert the Null value to Type Text; Power Apps Launches, We cannot covert the Null value to Type Text; Business Process Flows, We cannot covert the Null value to Type Text; .........

Expected Behavior

It was expected to get a dialog box asking for "CoE Starter Kit Environment URL:" value after opening Open Production_CoE_Dashboard_March2024.pbit file

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.24

What app or flow are you having the issue with?

Power BI Report for "Production CoE"

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

Power BI issue (3) Power BI issue (4)

Anything else?

Nothing else

AB#2902

Jenefer-Monroe commented 7 months ago

In this list of errors, can you please scroll to see if there are any error messages that are different than the ones shown? image

Please also share a screenshot like this so we can see what solutions you have installed in this environment? Be sure to show all records (all rows) and expand the indicated columns so that we can see full names image

reymesEDC commented 7 months ago

Hello Jenefer, I am trying to replicate the same scenario triggering the error, but I am getting a new screen that I was not getting before when loading that "Production_CoEDashboard_March2024.pbit" file: image

As you can see is asking for a "Tenant Type" value in addition to the regular "CoE Starter Kit Environment URL" as it was before: image

Which of the following values should I set for that Tenant Type?: image

Another question...... Is it possible to update that CoE Starter kit package by using another means other that Power BI Desktop? Is it possible by using the actual Power BI website (https://app.powerbi.com/)? Any documentation? You ask for Solutions installed in the environment: image

I think that "Center of Excellence - Core Components" version 4.24 is the only Solution we have at the moment. I will send of the rest of errors in the list once you help me out with what to choose in that "Tenant Type" entry I mentioned before that is new for me. Regards,

Reymes Madrazo-Rivera

Jenefer-Monroe commented 7 months ago

Yes we added an additional parameter as we added links to objects and that requires knowing the cloud you are in. If you don't know you are likely commercial. The rest are Government clouds where Microsoft hosts only their objects for isolation purposes.

Honestly I dont know if its possible to do this in PowerBI.com. I am not a Power BI expert, to my knowledge you cannot and have to do this in the desktop version but others in the community may know.

reymesEDC commented 7 months ago

Hello Jenefer, I applied the solution provided by G1982C on January 9th, 2024 and it worked for me:

reymesEDC commented 7 months ago

Solution found and applied. Thanks