Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Issue with Semantic Model Not Working in Power BI Service

I am currently developing a dashboard in Power BI that pulls data from three different sources: a database, an Excel file, and a semantic model located in the same workspace as the dashboard. While ...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Anonymous
    If you are still unable to publish you Semantic Model, consider checking out  the Issues forum here:

    https://community.powerbi.com/t5/Issues/idb-p/Issues

    And if it is not there, then you could post it.
    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to

    https://support.powerbi.com. 
    Hope this helps!
    If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You!

Wikkleyn_81's avatar
Wikkleyn_81
Super User
1 year ago

Hi Anonymous From your first screenshot, it doesn't look like you have a gateway installed.

 

You mention you have a database, excel and dataset as your sources. From that screenshot, the connection to your dataset should be sorted.

 

The database is that an on-prem db or is it in Azure?

The excel file, what is the path to the excel file? Is it on your laptop or to a path on a server? My recommendation would be to rather use OneDrive or SharePoint for an excel file. That would remove the need for a gateway connection.

https://support.cloudextend.io/en/articles/5473095-get-excel-data-from-a-single-file-or-entire-folder-on-sharepoint-or-onedrive-for-business-into-power-query-or-power-bi