How can i gain access to a semantic model and share to others in my dashboard

[Edin_n]

I created a report in power bi, i have as source excel and a semantic model,

I gain access to this semantic model beacuse of being in the same organisation, 
and its working in power bi desktop,
but.. when i click publish shows error as below, and then when I share the report to others fails to show data, from source semantic model.

in publish mode shows this error.

this is relation I suppose.

How to fix, any idea?

[Ray_Minds]

Hi @Edin_n 
As you mentioned that, the report is okay on desktop power bi.  
 
Below are steps that may help you identify the root cause of the issue: - 
 
(I) Please try to refresh your semantic model in Power BI Desktop and check if you are getting any error. 
 
(II) Check for necessary source permissions, In Power BI Desktop, go to File > Options and settings > Data source settings. Check that the connections are set up correctly and that there are no issues with the Excel file or the semantic model connection.   
 
(III) If you identify any data sources you don't have access to in the semantic model, you'll need to request permissions from the administrator or owner of those sources. 
 
(IV) If the semantic model is on-premises, please make sure you have a properly configured data gateway that is set up to connect to the on-premises semantic model. Ensure that the data source for your semantic model is added to the gateway and the credentials are set up correctly. 
 
(VI) If the Excel file is located on your local machine, try uploading it to SharePoint. Then, update the source connection in Power BI Desktop, refresh the semantic model within Power BI Desktop, and check if you are still encountering any errors. 
 
If suggested steps helped in identifying your issue, you can let us know by marking my post as a solution which can help the other community members to find it more quickly. 

[vikramgosain]

Thanks Rayminds 
This helps a lot.

[nandic]

@Edin_n what it says when you click on "show details?"
Could you share whole page relevant to settings of dataset in Power BI Service? Is section regarding data credentials greyed out?

[Edin_n]

Yes, is greyed out! cant click on that!

[Edin_n]

when i click show details, it shows this one.

the clickable links on this image rederects to https://app.powerbi.com/

I cant find credentials anywere.

[nandic]

@Edin_n when you go to this new dataset settings on Power BI Service, do you get error "One or mode cloud data sources for this semantic model have been deleted.":

If yes, this is because you are mixing live connection to new Excel file that you added - which is i suppose located on your local machine?
In that case, Power BI Service doesn't know how to refresh data which is stored locally on your machine so you need to instal Power BI Gateway.
Once you have it, you will be able to map it. Check more details on this link: https://analyticsphx.com/troubleshooting/power-bi-how-to-fix-one-or-more-cloud-data-sources-for-this...

If Excel is not located on your local machine, but on some shared location (onedrive, sharepoint), let me know and will check further options.

Cheers,
Nemanja

[Edin_n]

Hi Nemanja,
Thanks you for the  reply!

The report is okay on desktop power bi,
When publish and then in web it shows erorrs,
Tabels and graphs that are using excel files as data source, are showing perfectly, desktop and web(before, after publish).

Problem: is with the semantic model that is failing to show data, and ask like the image below: