Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 months ago
Solved

Cannot publish to Power BI

Hi All   I am trying to separate out my original PBIX file which contained report pages and semantic model into:   File1: Reports only File2: Semantic Model only   File1 gets published fine bu...
Need Help
  • Anonymous's avatar
    Anonymous
    9 months ago

    Found the problem.

     

    I had tried to delete all report pages in my PBIX file, and I think that (a) either this is not allowed, or (b) the file got corrupted somehow in this process.

     

    So now, I have deleted all report pages except the 'main' report page, then I just hid the main report page.

     

    The file now uploads into PBI without problem. 

     

    Hope this helps someone else out there with the same issue.

     

Ahmed-Elfeel's avatar
Ahmed-Elfeel
Icon for Super User rankSuper User
9 months ago

Hi Anonymous,

Here are the top things to check and try, in order of likelihood:

When you save a semantic model only file, Power BI Desktop might be saving it in the new Power BI Project (PBIR) format instead of the traditional PBIX format (The PBIR format is not yet supported in all environments)

 

To Fix this :

  • Open your File2.pbix in Power BI Desktop.
  • Go to File > Options and Settings > Options.
  • Select the Save tab on the left
  • Make sure that the option for Save .pbix files as Power BI Project files is UNCHECKED
  • Now save your file (you might want to do a Save As to be safe)
  • Try publishing this newly saved file again

 

Another Approach:

If the direct publish still fails you can often bypass the issue entirely by uploading the file:

  • Go to your Power BI Service workspace in a web browser.
  • Click on Get Data
  • Choose Files and then select Local File
  • Browse to and upload your File2.pbix

Note: 

  • This process achieves the same result as publishing from the Desktop and often works when the standard method fails

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Thanks for your suggestion, Ahmed-Elfeel

 

In File > Options, I see no mention of 'Power BI Project' files, and my files are always stored as PBIX, so I assume this is not the issue.

 

Your second idea to go to PowerBI Service and 'Get Data' (in my version of PBI Service it seems to be called 'Import' for some reason), uploading my local File2.pbix file also does not work. I get the same "unknown error" as before.

 

There must be something wrong with the way I have deleted the reports to arrive at File2.pbix but Microsoft (being Microsoft) do not seem to understand the power of informational error messages. Instead, I get random garbage with Request IDs, Access IDs and Error Codes which state 'unknown'. (Been working with Microsoft technologies since the early 1990s, so nothing new there...)

 

Will keep poking around...

 

Thanks anyway !