Forum Discussion
Can't refresh a report
Community ChampionHi JKrason ,
Have to get to work, but will check back later. It sounds as if there may be a difference in the credential used locally, and on the service...betting it is the excel sheet on sharepoint. Sharepoint can be different in the two connections. Like I said, try a new pbix that only connects a spreadsheet. Then publish, and see if the gateway works. Google connecting to sharepoint from the service. I will see if I can find an article.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Community ChampionHi JKrason ,
From my notes when I did this for the service.
Power BI open a SharePoint file
- Go to the file and open it as an excel file
- Go to info and copy the path
- Paste to Notes delete everything after the .xlsx in the path
- Copy the remainder to Power Query by using new source and using the Web connector
Found this at How to Connect to a Specific file from SharePoint to Power BI - EnjoySharePoint
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
I published a single pbix with just a sharepoint excel connected and it works. The error in main file says it's a problem with one of the cube's. I have another report made out of those 2 cubes and it works fine as well, everything seems to be almost the same, but this file recieve an error while you try to refresh it.
