cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cbardo13
Regular Visitor

Composite Model not displaying visuals while published

Hey everyone,

 

I'm reaching out here to see if anyone has had issues with publishing a composite model to the Power BI Service.   

 

I am currently connecting 3 data sources:

-Live Connection to Gen2 Metrics

-API Connection to Microsoft Admin APIs

-SQL connection (1 table)

 

These are all joined properly and work correctly on the desktop (see below):

Private data has been covered

cbardo13_0-1631105130748.png

 

After publishing this is what my report looks like:

cbardo13_1-1631105235853.png

 

Every visual that is broken has at least one piece from the live connection to Gen2 Metrics.

Here is the error provided (which doesn't really give any details to the problem)

cbardo13_3-1631105474679.png

 

Has anyone else run into this issue?  Again, everything works fine on the desktop application.

 

Thank you in advance!

 

 

 

6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

Hello everyone, maybe it is related to your problem:

Since August 28, 2021 there are refreshment problems with the Dataset "Gen2 Utilization Metrics".

In the last update (v15), the following banner appeared in the report generated by the app:

agarciagarcia_0-1631204910873.png

Upgrading to the new version (v15) has fixed refresh issues


In my case, I connect other datasets to the "Gen2 Utilization Metrics" dataset, but I would be interested in being able to connect directly to the "MetricsCES" Datasource, is this possible?

Hey,


When was your last update?   I did mine on 8/11/21 -- My refreshes have worked perfectly since then


The update appears to have added some IDs to the dataset (which is great because they previously weren't there, except in a concat on the Artifact... which wasn't helpful at all because we can't do any transform on that dataset).

 

The way I connected to the dataset was through a live connection, so I used the Existing Gen2 Metrics by choosing "Power BI Datasets" and searching my Gen2.   This is great and all, but not really functional except on the desktop.   I was able to correlate Admin APIs to see which activities were being used at what time, and how much CPU each activity was using.   Still not quite what I wanted because the Gen2 Metrics dataset does not include "ActivityID", I had to join on a cross filter of date... so in the end, its still just an approximation at the time.  Unfortunately all of this was a waste because after I publish the report none of the visuals show up, I can't connect to my personal gateway due to the datasource of Gen2 Metrics...  It wont even let me.   My gateway works for all other workspaces except this one. 




amitchandak
Super User
Super User

@cbardo13 , Open your workspace. In that search you datasets, on the three dots click and open setting.

 

You need either provide on-premise gateway details or data source credentials based on the type of dataset.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Thank you -- I will try this out.   It looks as though I'm having personal gateway issues.   Also I guess it didn't really make sense to me why an API call (Essentially what Gen2 metrics is) had to use a gateway. 

We don't really use Personal Gateways, so I haven't even checked that.   

I'll give it a shot and see if that can resolve the issue.

So I tried out a few different methods, my personal gateway works everywhere else but this workspace and I fear its because of the source.   

It looks like its still being restricted no matter what method or approach I take.   Essentially the Gen2 Metrics seem like a restricted API where you dont actually get to use your credentials to access it, they just give you direct query access.

I will have to look into other options. 

cbardo13
Regular Visitor

https://community.powerbi.com/t5/Desktop/Issue-with-Composite-Model-Visuals-not-displaying-for-other...

Found this link after the fact.   Will review this and mark as solved if it works 

If anyone has any other suggestions feel free to respond

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors