Composite Model don't show after de publish

[FernandoOliveir]

Hello everyone!

I'm creating a power bi dashboard with a composite model. That model is composite by a PowerBi Dataset(direct imported from the headquarter of my organization) and an excel source made by myself. Everything is working fine in the powerbi desktop, but when i try to publish the dashboard on my workspace it stops working.

Someone know how can I fix this? Thanks!

Dashboard on BI Desktop - I tried to blur the numbers, because they are real net profit and some more financial numbers, but consider all BI cards working correctly.

Dashboard after I publish: 

[v-yueyunzh-msft]

Hi , @FernandoOliveir 

According to my understanding of the Power BI composite model dataset, if you publish the corresponding report to the Power BI service, because it contains the content of the Direct query link, it means that your Power BI service needs to refresh the data source in real time through the configured credentials when accessing the content of the Direct query link of this report, if you are not direct Query link configuration credentials or incorrect credential configuration will cause the visual to load an error, so my suggestion is that you need to first go to the dataset settings and find the "! , select Click Edit credential to re-enter and configure credentials for them:

For details, you can also check out this official document:
Configure scheduled refresh - Power BI | Microsoft Learn

If the data source credentials are all configured correctly, or there is a loading error, you can expand the corresponding error message and reply the error in text format here for further study.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[FernandoOliveir]

Thanks for reply.

I can't select this option. I tried to install a personal gateway, but it's still dont show the option:

[v-yueyunzh-msft]

Hi , @FernandoOliveir 

According to the screenshot provided by your example, your "Edit credential" option is not activated, you need to first expand the "Gateway conection" option to find the gateway you just installed, and select "Add to gateway" for the corresponding data source to configure the gateway data source credentials to activate the gateway connection for data:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly